Excel 5.0c for Windows: Summary List of Known Issues

ID: Q119376


The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0c


SUMMARY

The following is a list of bugs confirmed in Microsoft Excel version 5.0c for Windows. This is not a comprehensive list and is current as of August 31, 1994.

For more information on the specific bugs listed in this article, query in the Microsoft Knowledge Base on the article ID (Qnnnnnn).

==========================

BUG LIST FOR VERSION 5.0c

  • XL5: GP Fault When Macro Closes Its Own Workbook


  • XL5: GP Fault Using Tab Scrolling Button in Embedded Worksheet


  • XL5: Formatting and Charts Not Saved to .WQ1 Format


  • XL5: Custom Default Chart Format Not Applied to Embedded Chart


  • XL5: Problems Scaling Embedded Excel Chart Object in Word


  • XL5: GP Fault in VBA.DLL on Exit After Saving to Floppy Drive


  • XL5: Can't Link to Worksheet with Exclamation Point in Name


  • XL5: Functions Not Saved to Quattro Pro File Format


  • XL5: GP Fault If Many Line Continuation Characters in Module


  • XL5: Infinite Loop If OLE Automation Server Busy


  • XL5: Chart References to Pivot Table Not Updated Correctly


  • XL5: Embedded Chart Object Grouped with Drawing Objects


  • XL5: Save As or Delete Dialog Box Doesn't Close on OK


  • XL5: "Linked Document Is Unavailable" Editing Linked Chart


  • XL5: OLE Automation Error Using Quit Method with GetObject


  • XL5: Can't Open File with Chart That Refers to Bound Worksheet


  • XL: Excel Hangs Deleting Toolbar Shortcut Submenu Item


  • XL5: Excel Displays Alerts when Activated Using CreateObject


--------------------------------------------------------------------
XL5: GP Fault When Macro Closes Its Own Workbook
Article ID: Q108507

In Microsoft Excel, you may receive a general protection (GP) fault if a Visual Basic macro is started by an OnSheetDeactivate command and the macro then closes the workbook in which it is contained.

--------------------------------------------------------------------
XL5: GP Fault Using Tab Scrolling Button in Embedded Worksheet
Article ID: Q109977

If you edit an embedded Microsoft Excel worksheet object in a Microsoft Word for Windows document, and the first sheet in the embedded workbook is hidden, you may receive a general protection (GP) fault when you click the first tab scrolling button on the worksheet.

--------------------------------------------------------------------
XL5: Formatting and Charts Not Saved to .WQ1 Format
Article ID: Q110708

In Microsoft Excel, the formatting and any chart sheets contained in the file may be lost when you save the file in the Quattro Pro for DOS (.WQ1) file format (a format used by Borland International's Quattro Pro spreadsheet application).

--------------------------------------------------------------------
XL5: Custom Default Chart Format Not Applied to Embedded Chart
Article ID: Q110829

In Microsoft Excel, when you create an embedded chart, the built-in default chart format is always applied (even when you select a custom chart format as the default).

--------------------------------------------------------------------
XL5: Problems Scaling Embedded Excel Chart Object in Word
Article ID: Q111805

When you scale a Microsoft Excel Chart object in a Microsoft Word for Windows document, the chart plot area may be scaled while the chart text and legend, as well as the object frame, remain unchanged.

When you scale a chart object that is an embedded chart, the chart in the object is displayed off center, its worksheet cells are visible, and the Chart object frame returns to its original size.

--------------------------------------------------------------------
XL5: GP Fault in VBA.DLL on Exit After Saving to Floppy Drive
Article ID: Q111906

In Microsoft Excel, if you save a workbook that contains a Visual Basic module to a floppy disk, and then remove the floppy disk from the disk drive, if you then save the file with the same filename to another drive, you receive the following error message
File already exists
and then the following error message:
Document not saved
When you quit Microsoft Excel, you receive a general protection (GP) fault in module VBA.DLL.

--------------------------------------------------------------------
XL5: Can't Link to Worksheet with Exclamation Point in Name
Article ID: Q111941

If you link information from a Microsoft Excel worksheet to a client application when the worksheet name contains an exclamation point (!), one of the following may occur:

  • You receive an error message in the client application

    -or-


  • The information appears in the client application, but the link cannot be edited or updated


--------------------------------------------------------------------
XL5: Functions Not Saved to Quattro Pro File Format
Article ID: Q111981

In Microsoft Excel, when you save a worksheet to the Quattro Pro for DOS (.WQ1) file format, if the file contains any of the following functions


   - N()
   - T()
   - NPER()
   - FV() - only if you use the optional arguments pv and type
   - PMT() - only if you use the optional arguments fv and type
   - PV() - only if you use the optional arguments fv and type 


you receive the following error message:
Cannot write record. (Cell: A1)
This error message appears with the reference of the cell that contains one of the functions listed above. When you open the file you saved, the cell that contained one of the functions listed above now contains the value of the function, but the function is gone.

--------------------------------------------------------------------
XL5: GP Fault If Many Line Continuation Characters in Module
Article ID: Q111984

In Microsoft Excel, you may receive a general protection (GP) fault if you copy and paste lines of code that contain the line-continuation character (_) in a Visual Basic subroutine.

--------------------------------------------------------------------
XL5: Infinite Loop If OLE Automation Server Busy
Article ID: Q112030

If you use the CreateObject function in a Visual Basic procedure in Microsoft Excel to create an OLE Automation object, and you then request information from the object (for example, to display a dialog box), if you switch back to Microsoft Excel (the Client application), you may receive the following error message:
Microsoft Excel is waiting for another application to complete an OLE action
The only available buttons are OK and Help. The error message continues to appear when you choose OK.

--------------------------------------------------------------------
XL5: Chart References to Pivot Table Not Updated Correctly
Article ID: Q112031

In Microsoft Excel, if you create a chart from data in a pivot table, and you move either the chart or the pivot table to another workbook, changes you make to the pivot table while the workbook containing the chart is closed may not be reflected in the chart.

--------------------------------------------------------------------
XL5: Embedded Chart Object Grouped with Drawing Objects
Article ID: Q112078

In Microsoft Excel, if you create multiple drawing objects on a worksheet and group them, and you then create an embedded chart object, the chart becomes part of the group when you close and reopen the file that contains the objects. This problem occurs whether you group the drawing objects before or after you create the embedded chart.

--------------------------------------------------------------------
XL5: Save As or Delete Dialog Box Doesn't Close on OK
Article ID: Q112178

In Microsoft Excel when you use the SAVE.AS? function or the FILE.DELETE?

function in a Microsoft Excel version 4.0 macro sheet, and you use 
ERROR(FALSE) to avoid displaying error messages, the Save As or the Delete dialog box does not close when you choose OK.

--------------------------------------------------------------------
XL5: "Linked Document Is Unavailable" Editing Linked Chart
Article ID: Q112348

When you edit a linked Microsoft Excel version 4.0 chart object in an object linking and embedding (OLE) version 1.0 application (the client), one of the following may occur:

  • In Microsoft Write, you receive the following error message:
    Linked document is unavailable
    -or-


  • In Microsoft Word for Windows version 2.0, the chart object does not open for editing.


--------------------------------------------------------------------
XL5: OLE Automation Error Using Quit Method with GetObject
Article ID: Q114225

If you use the GetObject function with a filename in a Microsoft Visual Basic version 3.0 procedure to open a Microsoft Excel workbook and you then use the Quit method to quit Microsoft Excel, the following error message appears:
OLE Automation error. Worksheet does not have Quit method.
--------------------------------------------------------------------
XL5: Can't Open File with Chart That Refers to Bound Worksheet
Article ID: Q118957

In Microsoft Excel, when you open a Microsoft Excel version 4.0 file that contains a chart with references to a bound worksheet, one of the following occurs if the worksheet name contains a bracket character ([]):

  • If the file is a workbook, and the sheet that contains the chart is the first sheet in the workbook, you receive the following error message:
    Cannot load an empty Microsoft Excel 4.0 workbook
    -or-


  • If the file is a workbook, and the sheet that contains the chart is NOT the first sheet in the workbook, you do not receive an error message, but the workbook does not open.

    -or-


  • If the file is a worksheet or a chart, you do not receive an error message, but the worksheet or chart file does not open.


--------------------------------------------------------------------
XL: Excel Hangs Deleting Toolbar Shortcut Submenu Item
Article ID: Q118959

In Microsoft Excel, when you delete a custom submenu item from the Toolbar shortcut menu using the Delete method in a Visual Basic, Applications Edition, procedure, your computer stops responding.

--------------------------------------------------------------------
XL5: Excel Displays Alerts when Activated Using CreateObject
Article ID: Q119378

When you use the CreateObject function in a Visual Basic version 3.0 procedure to create a Microsoft Excel OLE Automation object, the procedure returns an error message if Microsoft Excel is already running.

--------------------------------------------------------------------

Additional query words: 5.00c xl5c

Keywords :
Version : 5.00c
Platform : WINDOWS
Issue type :


Last Reviewed: April 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.