The information in this article applies to:
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. BUG LIST FOR VERSION 5.0
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 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. -------------------------------------------------------------------- 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 you receive the following error message: 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: -------------------------------------------------------------------- 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: 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 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 and then the following error message: 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:
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: -------------------------------------------------------------------- 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:
-OR- -------------------------------------------------------------------- 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 : |
|
Last Reviewed: April 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |