Lotus Spreadsheet Partially Loads in Excel 3.0

Last reviewed: November 1, 1994
Article ID: Q69817

SUMMARY

Some Lotus spreadsheets will attempt to load, but fail at between 0 and 10 percent. One possible solution is to clear the defined name PRINT_AREA in the Lotus sheet before you attempt to load it into Excel 3.0.

MORE INFORMATION

The same Lotus sheet will load correctly into earlier versions of Excel. The problem arises when you have the following three conditions:

If you have a defined name PRINT_AREA in your Lotus sheet
If you have another defined name that refers to part of the area in which PRINT_AREA has been defined
If you have set a print range anywhere in the Lotus sheet

The easiest and quickest way to enable the sheet to load properly in Excel 3.0 is to clear the defined name PRINT_AREA. However, you can also take the Lotus sheet into an earlier version of Excel and save it there. At this point, the file (.XLS) should load correctly into Excel 3.0.

Microsoft is researching this problem and will post new information here as it becomes available.

KBCategory: kb3rdparty
KBSubcategory:
Additional reference words: noupd

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 1, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.