Microsoft KB Archive/119769

{|
 * width="100%"|

Excel 5.0c for Windows: List of Fixed Problems

 * }

-

The information in this article applies to:


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

XL5: Formulas Incorrect When File Saved in SYLK Format

Q109297

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!

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: Sheets in Wrong Orientation with Print Entire Workbook

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

--

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

-or-

where is a word that is in the spelling dictionary, and is a word that is not in the spelling dictionary.

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

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

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.

XL5: "Cannot Find Macro" Running Macro in Active Workbook

Article ID: Q115905

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

Negative Number in Query Incorrect When Returned to Worksheet

Article ID: Q117313

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-

- the error message "Margins do not fit page size."

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

where BOOK1.XLS is the name of the workbook that contains the worksheets that you want to consolidate, and SHEET* is the reference that you entered to consolidate all of the worksheets that begin with the word SHEET.

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

XL5: GP Fault Using Shared Formula as Computed Criteria

Article ID: Q118756

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

you receive a general protection (GP) fault when the cell that the defined name refers to changes.

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

XL5: Caller Does Not Return Hierarchical Menu Information

Article ID: Q118796

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'

where the name of the function that you use appears in the place of EDATE in the above error message.

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

you may receive the following error message:

Argument not optional

MSQUERY: "Can't Group By..." Error Adding Criteria

Article ID: Q119094

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

MSQUERY: "Invalid Path" Using Access 2.0 Driver

Article ID: Q119320

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

XL5: GP Fault Evaluating INDIRECT in Defined Name on Chart

Article ID: Q119377

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.

Additional query words: 5.00c xl5c buglist bug bugfix

Keywords : msquery

Version : 5.00c

Platform : WINDOWS

Issue type :

Technology :