Microsoft KB Archive/94565

= Microsoft Knowledge Base =

Excel: System Error When Opening Multiplan Worksheet in Excel
Last reviewed: September 23, 1997

Article ID: Q94565

4.00 5.00 | 4.00 4.00a 5.00 MACINTOSH | WINDOWS kberrmsg

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
 * Microsoft Excel for the Macintosh, versions 4.0, 5.0

SYMPTOMS
If you open a version 4.2 Microsoft Multiplan for MS-DOS worksheet in Microsoft Excel version 5.0 for Windows, you receive the following error message

File error: data may have been lost and the cell that contained the function reads &quot;=N/A&quot; (without the quotation marks); however, the value the function returned is still displayed.

If you open a version 4.2 Multiplan for MS-DOS worksheet in version 4.0 of Microsoft Excel, you may receive a system error if the Multiplan worksheet contains any of the following functions:

DELTA ITERCNT NAME VERSION If your Multiplan worksheet contains one of the above functions, you receive one of the following system errors when you open the worksheet or when you activate a cell containing one of the above functions:

 A general protection (GP) fault, if you are using Microsoft Windows version 3.1. -or- An unrecoverable application error (UAE), if you are using Microsoft Windows version 3.0. -or- A Macintosh system error, if you are using a Macintosh computer.

WORKAROUND
To work around this problem, do the following:


 * 1) Open the worksheet in a version of Microsoft Excel that is earlier than version 4.0 (the #N/A! error will appear in cells that contain the problem functions).
 * 2) Save the worksheet as a normal worksheet.

You should now be able to open the file in your current version of Microsoft Excel without receiving a system error.

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. We are researching this problem, and will post more information here in the Microsoft Knowledge Base as it becomes available.