Excel 5.0c for Windows: List of Fixed Problems

• Microsoft Excel for Windows, version 5.0c

SUMMARY

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

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

FIX LIST FOR VERSION 5.0c

• XL5: Formulas Incorrect When File Saved in SYLK Format
• XL5: GP Fault If REFTEXT() Refers to Closed Workbook
• XL5: Embedded Chart Shrinks After Print or Print Preview
• XL5: Cannot Reopen Password-Protected File
• XL5: Name Value Not Updated If Worksheet Not Active
• Unexpected Results with Second Paste Link to Item
• XL5: Can't Define Global Name If Same Local Name Exists
• XL5: Can't Use Replace Command to Search for Blank Cells
• XL5: Sheets in Wrong Orientation with Print Entire Workbook
• XL5: GP Fault in Text Import Scrolling File with Large Columns
• XL5: Methods Fail When Embedded Chart Is Edited
• XL5: Can't Get or Set Properties of X Axis in XY Scatter Chart
• XL5: Unattached Text in Wrong Place on Zoomed Embedded Chart
• XL5: Can't Reference Name in Closed Excel 4.0 Workbook
• XL5: GP Fault Checking Spelling in Worksheet
• Selection.Cells with Nonadjacent Selection Returns Single Cell
• XL5: Chart Sheet Tab Contains Filename Extension When Opened
• XL5: GET.CHART.ITEM() Returns #Value! If Chart Item Selected
• XL5: GP Fault Pasting Multiple Grouped Drawing Objects
• XL5: Cannot Set Chart Data Marker Color Using Macro
• XL5: NAMES() Returns #N/A If Active Sheet Is Chart or Module
• XL5: "Cannot Find Macro..." Using Run Method with Add-in Macro
• Query: Error Using Decimal Values with Custom Expressions
• XL5: Reference to Remote Link Not Updated
• XL5: "Cannot Find Macro" Running Macro in Active Workbook
• Negative Number in Query Incorrect When Returned to Worksheet
• XL5: Refresh Data Command May Not Be Updated as Expected
• XL5: Macro Error Using GET.DOCUMENT(1) with Text File
• XL5: GP Fault Pasting Object in Protected Workbook
• XL5: GP Fault Using Size Command with Chart Corners Selected
• Copied Worksheet Reverts to Standard Row Height
• XL5: No Label Added to Subtotal in List
• XL5: Hidden Column/Row Not Saved in Text or CSV File Format
• XL5: Currency Number Format Lost When Entering Fraction
• XL5: DOCUMENTS() and WINDOWS() Return XL5GALRY.XLS Filename
• XL5: GP Fault Using Paste Name Dialog Box in Print Area
• XL5: GET.DOCUMENT(4) Returns FALSE After FOR.CELL Function
• XL5: Custom Function Doesn't Recalculate with Calculate Method
• Text Import Wizard Is Displayed Using OPEN?() with Text File
• GP Fault Exiting MS Query After Canceling Get External Data
• XL5: No Option to Save/Not Save Password with MS Query Add-in
• XL5: Errors Using Wildcard in Sheet Name with Consolidate
• XL5: GP Fault Using Shared Formula as Computed Criteria
• MSQUERY: GP Fault Deleting Column After Copy
• XL5: Caller Does Not Return Hierarchical Menu Information
• "Cannot Find" Using Analysis ToolPak Visual Basic Function
• XL5: DDE Poke Command Fails When Mouse Cursor Over Toolbar
• XL5: "Argument Not Optional" Using Visual Basic ATP Functions
• MSQUERY: "Can't Group By..." Error Adding Criteria
• MSQUERY: "Invalid Path" Using Access 2.0 Driver
• XL5: GP Fault Evaluating INDIRECT() in Defined Name on Chart

In Microsoft Excel version 5.0 for Windows, if you save a file in the SYMBOLIC LINK (SYLK) file format, close the file, and then open the file again, groups of similar formulas may be converted into a single array formula that displays incorrect results.

XL5: GP Fault If REFTEXT() Refers to Closed Workbook 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: Cannot Reopen Password-Protected File Article ID: Q111728

In Microsoft Excel version 5.0 for Windows, if you save a worksheet that contains an embedded chart as a password-protected Microsoft Excel 4.0 worksheet, you will receive a general protection (GP) fault if you try to open the file in Microsoft Excel version 5.0.

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.

Unexpected Results with Second Paste Link to Item Article ID: Q111904

In Microsoft Excel, if you use the Paste Link option in the Paste Special dialog box to link information from another application as an object or picture, and then link the same information as text, the link as text appears on the worksheet as follows:

   #VALUE!

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: 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 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 page orientation.

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

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 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: 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: GP Fault Checking Spelling in Worksheet Article ID: Q112027

In Microsoft Excel, you may receive a general protection (GP) fault when you check the spelling in a worksheet if a cell on the worksheet contains text in the following format

   <recognized word><period><space><unrecognized word>

   -or-

   <recognized word><space><unrecognized word>

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: 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: GET.CHART.ITEM() 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: 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: 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 change the color of that data marker with a macro.

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 workbook-level ("global") defined names.

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

Query: Error Using Decimal Values with Custom Expressions Article ID: Q113572

In Microsoft Query version 1.0, you receive the message "Syntax error" when you try to enter a custom expression that contains a decimal value but does not have a numeric value before the decimal point.

XL5: Reference to Remote Link Not Updated Article ID: Q115427

In Microsoft Excel version 5.0, a reference to a cell that contains a remote link is not updated if the following conditions are true:

• The cell that contains the reference refers to a cell on a following worksheet in the same workbook.

  -and-

• The following worksheet is linked to an external workbook.

  -and-

• The external workbook is not open when you open the linked workbook.

In a Visual Basic macro in Microsoft Excel, if you activate a sheet in another workbook, and you use the Run method to run a macro in the activated workbook, such as SHEET1!Auto_Activate, you receive the following error message:

   Run-time error '1004':

   Cannot find macro 'SHEET1!Auto_Activate'.

In Microsoft Excel, when you return data from a query in Microsoft Query, negative numbers are returned as positive numbers. For example, the value -1 in Microsoft Query is returned as 65535, the value -2 is returned as 65534, and so on.

XL5: Refresh Data Command May Not Be Updated as Expected Article ID: Q118304

In Microsoft Excel 5.0, when you choose the Refresh Data command, the data in your worksheet may not be updated as expected.

XL5: Macro Error Using GET.DOCUMENT(1) with Text File Article ID: Q118414

In Microsoft Excel, if you use the GET.DOCUMENT(1) function in a macro to return the name of the active document, for example to parse or process information in the file, you may receive a macro error if the file is in the Text, CSV, SYLK, or PRN file format.

XL5: GP Fault Pasting Object in Protected Workbook Article ID: Q118415

In Microsoft Excel, when you paste an object to a worksheet in a workbook that has been password protected, you receive a general protection (GP) fault.

XL5: GP Fault Using Size Command with Chart Corners Selected Article ID: Q118416

In Microsoft Excel, if you select the corners on a chart, and you then choose the Size command (from the Format menu with Microsoft Excel 4.0 Menus displayed) you receive a general protection (GP) fault when you click on the chart.

Copied Worksheet Reverts to Standard Row Height Article ID: Q118417

In Microsoft Excel, if you copy an empty worksheet to a new or existing workbook, and you have changed the row height on the worksheet, the worksheet rows revert to the standard row height in the copy of the worksheet. Additionally, even if the worksheet contains information, certain rows on the worksheet may revert to the standard row height when you copy the sheet.

XL5: No Label Added to Subtotal in List Article ID: Q118418

In Microsoft Excel, when you use the Subtotal feature to create subtotals in a list of data, there is no label describing the subtotal value in the list.

XL5: Hidden Column/Row Not Saved in Text or CSV File Format Article ID: Q118600

In Microsoft Excel, when you hide a column or row in your worksheet, and you then save the file to the Text or CSV file format, the hidden column or row is not saved.

XL5: Currency Number Format Lost When Entering Fraction Article ID: Q118601

In Microsoft Excel, if you enter text that resembles a fraction in a cell that is formatted with a currency number format, the number format changes to a fraction format.

XL5: DOCUMENTS() and WINDOWS() Return XL5GALRY.XLS Filename Article ID: Q118602

In Microsoft Excel, if you use the DOCUMENTS() or the WINDOWS() macro function to return a list of open documents or document windows, the filename XL5GALRY.XLS is returned in this list.

XL5: GP Fault Using Paste Name Dialog Box in Print Area Article ID: Q118603

In Microsoft Excel, if you use the Paste Name dialog box (by pressing F3) to enter a defined name in the Print Area box in the Page Setup dialog box, you may either receive

- a general protection (GP) fault

  -or-

XL5: GET.DOCUMENT(4) Returns FALSE After FOR.CELL Function Article ID: Q118654

In Microsoft Excel, if you use the FOR.CELL() macro function, and you then use the GET.DOCUMENT(4) function without the name_text argument, or with a workbook name, to return a value indicating whether changes have been made to the workbook since you saved it last, the value returned by this function is FALSE.

XL5: Custom Function Doesn't Recalculate with Calculate Method Article ID: Q118655

In Microsoft Excel, if you use the Calculate method to recalculate a custom function in a specified range on a worksheet, and you have the Manual calculation option selected, the function is not recalculated.

Text Import Wizard Is Displayed Using OPEN?() with Text File Article ID: Q118656

In Microsoft Excel, when you use the OPEN?() macro function to display the Open dialog box, the Text Import Wizard dialog box appears when you open a text file.

GP Fault Exiting MS Query After Canceling Get External Data Article ID: Q118657

When you use the Get External Data command in Microsoft Excel to link to a query in Microsoft Query, and you then cancel the query and exit Microsoft Excel, you receive a general protection (GP) fault when you exit Microsoft Query.

XL5: No Option to Save/Not Save Password with MS Query Add-in Article ID: Q118754

In Microsoft Excel, when you use the Get External Data command to link to a query in Microsoft Query, the dialog box that appears when you return to Microsoft Excel does not contain a password option; that is, you do not have the option to keep the password with your data.

XL5: Errors Using Wildcard in Sheet Name with Consolidate Article ID: Q118755

In Microsoft Excel, when you use a wildcard character in a sheet name in the Consolidate dialog box, you receive the following error messages

   Cannot open consolidation source file '[BOOK1.XLS]sheet*'

   Cannot find 'SHEET*'

   Cannot open consolidation source file 'SHEET*'

   No data was consolidated

Additionally, when you choose Consolidate again from the Data menu, the reference that you entered is listed twice in the All References list; once with the worksheet name in capitals, and once in lowercase, as in the following example:

   'sheet*'!$A$1
   'SHEET*'!$A$1

In Microsoft Excel, when you filter a list using computed criteria, and the following conditions are true

• The computed criteria contains a shared formula

  -and-

• The criteria is on a different worksheet from your list

  -and-

• The formula contains a defined name

MSQUERY: GP Fault Deleting Column After Copy Article ID: Q118757

In Microsoft Query, if you copy records in a query that contains a field with the Image data type, and you then delete one of the columns in the query, you receive a general protection (GP) fault.

Additionally, if you copy records in a query that contains only a field with the Image data type, and you then delete that column, you receive the following error message:

   Out of memory

In Microsoft Excel, when you use the Caller function, or the Caller property, and the macro currently running was started by choosing a menu command, the array of values returned does not include information about whether the command that ran the macro was located on a top level menu or on a submenu.

"Cannot Find" Using Analysis ToolPak Visual Basic Function Article ID: Q118797

In Microsoft Excel, if you use one of the functions provided in the Analysis ToolPak-Visual Basic for Applications add-in, (ATPVBAEN.XLA), such as EDATE(), you receive the following error message

   Run-time error '1004':

   Cannot find macro '[ATPVBAEN.XLA]REG!reg_EDATE'

XL5: DDE Poke Command Fails When Mouse Cursor Over Toolbar Article ID: Q118798

When you send dynamic data exchange (DDE) messages to Microsoft Excel from a client application, and you use the DDE POKE command, you do not receive an acknowledgment from Microsoft Excel if the mouse cursor is positioned over the toolbar in Microsoft Excel.

XL5: "Argument Not Optional" Using Visual Basic ATP Functions Article ID: Q118799

In Microsoft Excel, when you use any of the following Analysis ToolPak functions in a Visual Basic module

   GCD()
   LCM()
   MULTINOMIAL()
   IMPRODUCT()

   Argument not optional

In Microsoft Query, when you add criteria to a query created using SQL data source, you receive one of the following error messages:

• Can't Group By Bit Field

  -or-

• TEXT and IMAGE data types may not be used in a GROUP BY clause

In Microsoft Query, when you open a database using the Microsoft Access 2.0 ODBC Driver for Microsoft Office, you receive the following error message:

   Invalid Path

In Microsoft Excel version 5.0, if you open a Microsoft Excel version 4.0 chart file, and the chart has a reference that contains the INDIRECT() function in a defined name, you receive a general protection (GP) fault if you evaluate the reference in the formula bar.