Excel 5.0 for Windows: Summary List of Known Issues

• 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: Can't Define Global Name If Same Local Name Exists
• 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

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 '<ADDIN.XLA>!<Addin_Macro>'

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

   Cannot write record. (Cell: A1)

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

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: Can't Define Global Name If Same Local Name Exists Article ID: Q111905

In Microsoft Excel, if you define a global name, when a local name with the same name exists on the active worksheet, the value that the local name refers to is the value you defined for the global name and the global name is not defined on the workbook.

Additionally, in Microsoft Excel version 5.0 for Windows ONLY, when you add a global name using the Add button in the Define Name box, when a local name with the same name exists on the active worksheet, the global name appears in the Names In Workbook list, even though the global name is not created.

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

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

   Document not saved

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.

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

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> property of the axis class"

   -or-

   Run-time error '1005':
   "Unable to get the <property> property of the axis class"

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.