Microsoft KB Archive/119376

{|
 * width="100%"|

Excel 5.0c for Windows: Summary List of Known Issues

 * }

-

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: 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: 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: 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: 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 :

Technology :