The information in this article applies to:
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.
FIX LIST FOR VERSION 5.0c
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:
-------------------------------------------------------------------- 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: 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: -------------------------------------------------------------------- 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:
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:
-OR- -------------------------------------------------------------------- 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 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 <recognized word><period><space><unrecognized word>where <recognized word> is a word that is in the spelling dictionary, and <unrecognized word> 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 where <ADDIN.XLA> is the name of the add-in that contains the macro, and <Addin_Macro> 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:
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: -------------------------------------------------------------------- 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 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:
-------------------------------------------------------------------- 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
-------------------------------------------------------------------- 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: -------------------------------------------------------------------- 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 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
you may receive the following error message: -------------------------------------------------------------------- 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:
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: -------------------------------------------------------------------- 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 |
Last Reviewed: April 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |