Changing the File Format from Lotus 1-2-3 to Excel

 Last reviewed: November 2, 1994
Article ID: Q30971
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 2.21, and 3.0

SYMPTOMS

When converting a Lotus 1-2-3 file format to an Excel file format, manually changing the extension from .WKS, .WK1 or .WK3 to .XLS during a Save does not work correctly. Any changes made to the file, such as formating, will not save.

WORKAROUND

You must use the following procedure to save a Lotus file in Excel file format:

  1. Load the Lotus file into Excel.

  2. From the File menu, choose the Save As command.

  3. Select Options.

  4. Choose Normal, then press ENTER.

    Microsoft Excel 5.0 ------------------- Choose Microsoft Excel Workbook, then press ENTER.

A common symptom of incorrect conversion is that formatting changes will not be saved if you do not use the File Save As command.

KBCategory: kbusage
KBSubcategory:

Additional words: 2.00 2.0 2.01 2.10 2.1 3.00 3.0 4.00 4.0 5.00

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 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.