ID: Q132438
The information in this article applies to:
The following is a list of confirmed fixed bugs in Microsoft Excel version 5.0a for the Macintosh. This is not a comprehensive list and is current as of June 15, 1995.
For more information on the specific fixes listed in this article, query in the Microsoft Knowledge Base on the article ID (Qnnnnnn).
QNumber Title
-----------------------------------------------------------------------
Q121527 MXL5: Error Opening Files with System 7.5 and MacLinkPlus
Q121895 Embedded Microsoft Excel Chart Loses Data When Edited
Q122464 MXL5: Links Incorrect When Source Document(s) Closed
Q122666 XL5: DSUM/DAVERAGE Functions Fail with Computed Criteria
Q125641 MXL5: PivotTable Uses Incorrect Range If Selected with Mouse
Q125726 MXL5: Type 1 Error/Hang Saving File with 32-Bit Addressing On
Q126001 File Locking Is Not Supported Cross-Platform
Q126795 Cannot Set Paper Orientation in Page Setup for StyleWriter II
Q127203 MXL5: Type 1 Error Double-Clicking Excel File In the Finder
Q127788 MXL5: "Number must be between 1 and 32767" in Print Preview
Q127791 XL5: Cut/Paste Formula with Reference Returns #REF! Error
Q127938 MXL5: Formula Subtracting Equal Values Doesn't Return Zero
Q127939 MXL5: TAN() Function Returns Incorrect Result
Q128153 MXL5: Cell Reference Following Defined Name Isn't Updated
Q128191 MXL5: "Can't Access File" Opening File on Novell Server"
On a Macintosh with System 7.5 and MacLinkPlus installed, you receive the following error message when you open a Microsoft Excel version 5.0 file by double-clicking the file in Finder:
File was not created with the Application Microsoft Excel
In Microsoft Power Point, when you edit an embedded Microsoft Excel 5.0 chart on your slide, the data in the chart may be lost.
MXL5: Links Incorrect When Source Document(s) Closed ID: Q122464
In Microsoft Excel version 5.0 for the Macintosh, linked cells on your worksheet may display incorrect data. The value displayed may be zero, a very large number, or a very small number instead of the actual data.
XL5: DSUM/DAVERAGE Functions Fail with Computed Criteria ID: Q122666
In Microsoft Excel version 5.0 for the Macintosh and Microsoft Excel version 5.0 for Windows NT, the DSUM() and DAVERAGE() functions may return incorrect results if you are using computed criteria for your database.
MXL5: PivotTable Uses Incorrect Range If Selected with Mouse ID: Q125641
When you create a PivotTable in Microsoft Excel, if you use the mouse to select a range in a workbook other than the active workbook (the workbook that was active when you inserted the PivotTable), one of the following symptoms may occur when you choose either Next or Finish in the PivotTable Wizard-Step 2 of 4 dialog box:
-or-
Pivot Table field name is not valid
-or-
Cannot find <filename>
Cannot open PivotTable source file '<filename>'
MXL5: Type 1 Error/Hang Saving File with 32-Bit Addressing On ID: Q125726
In Microsoft Excel 5.0, when you save a file in the Microsoft Excel Workbook file format on a Macintosh that has 32-bit addressing turned on, your computer may stop responding or Microsoft Excel may close unexpectedly.
File Locking Is Not Supported Cross-Platform ID: Q126001
In the applications listed above, if you open a file located on a network server on both a personal computer running Microsoft Windows and a Macintosh computer simultaneously (that is, you open the file on a personal computer and then open the same file on a Macintosh computer), you do not receive a prompt to open the file as read only as in earlier versions of the applications.
Cannot Set Paper Orientation in Page Setup for StyleWriter II ID: Q126795
In Microsoft Excel, if you are using an Apple StyleWriter printer with version 1.2 of the StyleWriter II printer driver, you cannot set the Orientation option with a Visual Basic macro or with a Microsoft Excel 4.0 macro.
MXL5: Type 1 Error Double-Clicking Excel File in the Finder ID: Q127203
When you double-click a Microsoft Excel file in the Finder to open the file in Microsoft Excel, you may receive one of the following error messages:
Sorry, a system error occurred.
"Microsoft Excel"
error type 11
-or-
The application "unknown" has unexpectedly quit, because an error of
type 1 occurred
In Microsoft Excel, if you are using an Apple Personal LaserWriter SC printer driver, or an Apple LaserWriter II SC printer driver, you receive the following error message when you view your document in print preview:
Number must be between 1 and 32767
In Microsoft Excel, if you cut a formula that contains a reference to a cell on the worksheet that contains the formula, and you paste the formula to another worksheet, the reference in the formula appears as #REF!.
MXL5: Formula Subtracting Equal Values Doesn't Return Zero ID: Q127938
In Microsoft Excel, when you enter a formula that subtracts the result of one cell from another cell with the same result, the value returned by the formula may not be 0 (zero).
MXL5: TAN() Function Returns Incorrect Result ID: Q127939
In Microsoft Excel, when you use the TAN() function to return the tangent of a given angle, the value returned may be incorrect.
MXL5: Cell Reference Following Defined Name Isn't Updated ID: Q128153
In Microsoft Excel, when you enter a formula that contains a defined name followed by a cell reference, the reference is not updated when you move that referenced cell on the worksheet.
MXL5: "Can't Access File" Opening File on Novell Server ID: Q128191
In Microsoft Excel, when you open a file located on a Novell server, you may receive the following error message:
Can't access file
Additional query words: 5.00a
Keywords : xlmac kbfixlist
Version : MACINTOSH:5.00a
Platform : MACINTOSHLast Reviewed: February 6, 1998