Microsoft KB Archive/96122

= References May be Invalid when Importing Older Lotus 1-2-3 =

Article ID: 96122

Article Last Modified on 11/24/2003

-

APPLIES TO


 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition

-



This article was previously published under Q96122



SUMMARY
Files from Lotus 1-2-3 versions earlier than 2.01 may import incorrectly. Formulas and functions in the imported files may reference empty cells, data may appear to be missing, and the row numbers in cell references are increased by 8192.

For example, the formula =A4*A5 in the original Lotus file would become =A8196*A8197 when imported into Works for Windows.

Workaround

 * 1) Open the file in Lotus 1-2-3 version 2.01 or later and save the file as a different name.
 * 2) Open the file in Lotus Symphony version 3.0 or later and save in the .WKS format.

The third-party product discussed here is manufactured by a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Additional query words: 2.00 3.00 4.00 w_works conv ss convert 1.0 1.x 2.x release

Keywords: kbprb kb3rdparty KB96122

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.