Microsoft KB Archive/112180

{|
 * width="100%"|

Excel 5.0 for Windows: Summary List of Known Issues

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0

-

SUMMARY
The following is a list of bugs confirmed in Microsoft Excel version 5.0 for Windows. This is not a comprehensive list and is current as of March 4, 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.0

 * XL5: Custom Default Chart Format Not Applied to Embedded Chart
 * XL5: GP Fault When Macro Closes Its Own Workbook
 * XL5: "Cannot Find Macro..." Using Run Method with Add-In Macro
 * XL5: Chart References to Pivot Table Not Updated Correctly
 * XL5: NAMES Returns #N/A If Active Sheet Is Chart or Module
 * XL5: GP Fault If Many Line Continuation Characters in Module
 * XL5: Functions Not Saved To Quattro Pro File Format
 * XL5: Formatting And Charts Not Saved to .WQ1 Format
 * XL5: Methods May Fail When Embedded Chart Being Edited
 * XL5: Chart Sheet Tab Contains Filename Extension When Opened
 * XL5: Can't Link To Worksheet with Exclamation Point in Name
 * XL5: Embedded Chart Object Grouped with Drawing Objects
 * XL5: Save As or Delete Dialog Box Doesn't Close on OK
 * Selection.Cells with Nonadjacent Selection Returns Single Cell
 * XL5: Unattached Text in Wrong Place on Zoomed Embedded Chart
 * XL5: GET.CHART.ITEM Function Returns #Value! If Chart Item Selected
 * XL5: Can't Reference Name in Closed Excel 4.0 Workbook
 * XL5: Embedded Pie Chart Shrinks After Print or Print Preview
 * XL5: Name Value Not Updated If Worksheet Not Active
 * XL5: GP Fault in VBA.DLL on Exit After Saving to Floppy Drive
 * XL5: Problems Scaling Embedded Excel Chart Object in Word
 * XL5: "Linked Document Is Unavailable" Editing Linked Chart
 * XL5: GP Fault in Text Import Scrolling File with Large Columns
 * XL5: GP Fault If REFTEXT Refers to Closed Workbook
 * XL5: Can't Use Replace Command to Search for Blank Cells
 * XL5: Cannot Set Chart Data Marker Color Using Macro
 * XL5: Cannot Print Multiple Copies to DeskJet 500C/500C Driver
 * XL5: Excel Hangs in Print Preview Using SpeedSTAR PRO Driver
 * XL5: Can't Get or Set Properties of X Axis in XY Scatter Chart
 * XL5: GP Fault Pasting Multiple Grouped Drawing Objects
 * XL5: Sheets in Wrong Orientation with Print Entire Worksheet
 * XL5: GP Fault in XLODBC.DLL Using SQLExecQuery or SQLREQUEST

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: GP Fault When Macro Closes Its Own Workbook

Article ID: Q108507

In Microsoft Excel version 5.0 for Windows, 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: "Cannot Find Macro..." Using Run Method with Add-In Macro

Article ID: Q112219

In a Visual Basic module in Microsoft Excel, if you use the Run method of the Application object to run a macro located in an add-in, you may receive the following error message

Run-time error '1004':

Cannot find macro '!'

where  is the name of the add-in that contains the macro, and  is the name of the macro that you want to run.

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 may not be reflected in the chart while the workbook containing the chart is closed.

XL5: NAMES Returns #N/A If Active Sheet Is Chart or Module

Article ID: Q112179

In Microsoft Excel, if you use the NAMES function in a Microsoft Excel version 4.0 macro to return defined names on a workbook, the function returns the #N/A error value if the active sheet in the workbook is a chart or a module, even if the active workbook does contain defined names.

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: 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: Formatting and Charts Not Saved to .WQ1 Format

Article ID: Q110708

In Microsoft Excel version 5.0 for Windows, 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: Methods May Fail When Embedded Chart Is Edited

Article ID: Q111971

In Microsoft Excel version 5.0, the following methods may fail if the active sheet is an embedded chart that is currently being edited and if an object is not specified for the method:

- Charts Method (Syntax 2)

- DialogSheets Method (Syntax 2)

- Modules Method (Syntax 2)

- Sheets Method (Syntax 2)

- Worksheets Method (Syntax 2)

XL5: Chart Sheet Tab Contains Filename Extension When Opened

Article ID: Q112032

In Microsoft Excel, when you open a Microsoft Excel version 4.0, 3.0, or 2.1 chart file, the chart sheet tab contains the filename extension as well as the filename.

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

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

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 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: Formatting Not Saved to .WQ1 Format

Article ID: Q110708

In Microsoft Excel for Windows version 5.0, formatting may be lost when you save a file in the QuattroPro/DOS (.WQ1) file format (a format used by Borland International's Quattro Pro spreadsheet application).

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

Article ID: Q112178

In Microsoft Excel version 5.0, 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.

Selection.Cells with Nonadjacent Selection Returns Single Cell

Article ID: Q112028

In Microsoft Excel, when you use the Range method or the Selection property with the cells method in a Visual Basic module to return a nonadjacent selection of cells on a worksheet, only the first cell in the selection is returned.

XL5: Unattached Text in Wrong Place on Zoomed Embedded Chart

Article ID: Q111982

In Microsoft Excel version 5.0, if you open a Microsoft Excel version 4.0 worksheet that contains an embedded chart, and the worksheet is at a zoom magnification option other than 100 percent, unattached text on the chart appears in the wrong location when you view the worksheet at 100 percent.

XL5: GET.CHART.ITEM Function Returns #Value! If Chart Item Selected

Article ID: Q112077

In Microsoft Excel version 5.0, if you use the GET.CHART.ITEM function in a Microsoft Excel version 4.0 macro, the function may return the #VALUE! error value instead of the position of the selected chart item.

XL5: Can't Reference Name in Closed Excel 4.0 Workbook

Article ID: Q111983

In Microsoft Excel version 5.0, if you reference a name on a closed Microsoft Excel version 4.0 workbook, and the name is defined on a worksheet other than the first worksheet in the workbook, you receive the following error message

'name' on 'WORKBOOK' is not defined or is too complex

where name is the name you are referencing, and WORKBOOK is the name of the workbook that contains the name you are referencing. This error message appears when you create the reference as well as when you update the reference.

XL5: Embedded Pie Chart Shrinks After Print or Print Preview

Article ID: Q111249

In Microsoft Excel, when you choose Print or Print Preview from the File menu in a worksheet that contains an embedded 2-D or 3-D Pie chart, the chart may shrink in size.

XL5: Name Value Not Updated If Worksheet Not Active

Article ID: Q111903

In Microsoft Excel, if you use a defined name in a formula on a worksheet, and then change the value of that name when the active sheet is not a worksheet, the value of the defined name is not updated on the worksheet.

XL5: GP Fault in VBA.DLL on Exit After Saving to Floppy Disk 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: 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: "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: GP Fault in Text Import Scrolling File with Large Columns

Article ID: Q111944

In Microsoft Excel, when you open a text file and use the horizontal scroll bar under the preview window in the Text Import Wizard to scroll the columns in the file, you may receive a general protection (GP) fault.

XL5: GP Fault If REFTEXT Refers to Closed Workbook

Article ID: Q110595

In Microsoft Excel version 5.0, when you use the REFTEXT function in a Microsoft Excel 4.0 macro sheet, and the reference includes the name of a closed workbook, you receive a general protection (GP) fault.

XL5: Can't Use Replace Command to Search for Blank Cells

Article ID: Q111942

In Microsoft Excel, if you choose Replace from the Edit menu, and you leave the Find What box blank and choose Find Next, Replace, or Replace All to fill blank cells on a worksheet, you receive the following error message:

Search string must be specified

XL5: Cannot Set Chart Data Marker Color Using Macro

Article ID: Q112176

In Microsoft Excel, when the background or foreground color of a chart data marker is set to none, you cannot set the color of that data marker with a macro.

XL5: Cannot Print Multiple Copies to DeskJet 500C/500C Driver

Article ID: Q112037

If you are using a Hewlett-Packard (HP) DeskJet 550C or 500C printer driver version 3.0 or 3.1, you will not be able to print multiple copies from Microsoft Excel 5.0. Changing the number of copies in the Print dialog box will not affect the number of copies printed.

XL5: Excel Hangs in Print Preview Using SpeedSTAR PRO Driver

Article ID: Q112177

If you use the Diamond SpeedSTAR PRO 800x600 65K Small Fonts video driver, Microsoft Excel hangs when you view a document in print preview.

XL5: Can't Get or Set Properties of X Axis in XY Scatter Chart

Article ID: Q111972

In Microsoft Excel version 5.0, you may receive one of the following error messages when you attempt to set or return the x axis scale properties for an xy (scatter) chart:

Run-time error '1005':

"Unable to set the property of the axis class"

"-OR-"

Run-time error '1005':

"Unable to get the property of the axis class"

XL5: GP Fault Pasting Multiple Grouped Drawing Objects

Article ID: Q112175

In Microsoft Excel, if you group drawing objects on a worksheet, and you repeatedly group multiple object groups, you may receive a general protection (GP) fault when you copy and paste the group.

XL5: Sheets in Wrong Orientation with Print Entire Worksheet

Article ID: Q111943

In Microsoft Excel, when you open a workbook that contains worksheets with different page setup orientations, and you print the entire workbook, some of the worksheets may be printed with the wrong orientation.

XL5: GP Fault in XLODBC.DLL Using SQLExecQuery or SQLREQUEST

Article ID: Q114992

In Microsoft Excel, if you use the SQLExecQuery function or the SQLRequest function in a Visual Basic procedure, to run a query on an external data source, and your query is larger than 255 characters, you may receive a general protection (GP) fault when you run the procedure.

Additional query words:

Keywords :

Version : 5.00

Platform : WINDOWS

Issue type :

Technology :