Excel 5.0c for Windows: Summary List of Known Issues

• 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

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

   Document not saved

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

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

   Cannot write record. (Cell: A1)

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

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.

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.

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.

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.