Microsoft Excel 5.0a for the Macintosh: List of Fixed Problems

• Microsoft Excel for the Macintosh, version 5.0a

SUMMARY

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"

Q121527 MXL5: Error Opening Files with System 7.5 and MacLinkPlus

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

You are then asked to translate the file.

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.

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.

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.

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:

• The PivotTable is created from incorrect data


-or-


• You receive the following error message:

  Pivot Table field name is not valid



-or-


• You receive the following error messages:

  Cannot find <filename>

  Cannot open PivotTable source file '<filename>'

These problems occur only when you create a PivotTable from data in a Microsoft Excel list or database.

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.

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.

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.

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

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

In Microsoft Excel, when you use the TAN() function to return the tangent of a given angle, the value returned may be incorrect.

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.

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
Version : MACINTOSH:5.0a
Platform : MACINTOSH
Issue type :