XL5: Large File Size After Saving WK4 File as Excel Workbook

 Last reviewed: September 12, 1996
Article ID: Q123269
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c

SYMPTOMS

In Microsoft Excel, when you open a Lotus 1-2-3 WK4 file, and you save the file to the Microsoft Excel Workbook format, the file size may increase by a large amount.

CAUSE

This behavior occurs if you apply formatting to an entire column or row in a Lotus 1-2-3 WK4 file, and you then open the file in Microsoft Excel, and save the file as a Microsoft Excel workbook. For example, if you select column C on a worksheet in Lotus 1-2-3, apply a currency format, and then enter values in a few of the cells in column C, the file size may increase by a large amount when you open and save the file in Microsoft Excel.

Note that this behavior does not occur when you apply formatting to an entire column or row in the file while it is open in Microsoft Excel.

WORKAROUND

To avoid a large increase in the size of your Lotus 1-2-3 WK4 file, do the following before you save the file in Microsoft Excel:

  1. Select all of the blank cells below and to the right of the last cell on your worksheet that contains data.

    Note that there is no automatic way of locating the last cell on your worksheet that contains data.

  2. From the Edit menu, choose Delete, and then choose OK.

MORE INFORMATION

To open Lotus 1-2-3 WK4 files in Microsoft Excel, you must obtain the Lotus 1-2-3 WK4 File Converter. The Lotus 1-2-3 WK4 File Converter is available in application note WE1130 "Lotus 1-2-3 WK4 File Converter." You can obtain WE1130 from the following sources:

You can obtain this Application Note from the following sources:

  • Microsoft's World Wide Web Site on the Internet
  • The Internet (Microsoft anonymous ftp server)
  • The Microsoft Network (MSN)
  • Microsoft Download Service (MSDL)
  • Microsoft Product Support Services

For more information about obtaining the Lotus 1-2-3 WK4 File Converter, please see the following article(s) in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q122583
   TITLE     : XL5: Lotus 1-2-3 Release 4 for Windows File Converter
Lotus 1-2-3 is manufactured by Lotus Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

REFERENCES

Lotus 1-2-3 WK4 File Converter README.TXT

For more information about Opening A Document Created By Another Application, choose the Search button in Help and type: 

   opening files

KBCategory: kb3rdparty
KBSubcategory:

Additional reference words: 5.00 5.00c big grow



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: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.