References May be Invalid when Importing Older Lotus 1-2-3 (96122)


The information in this article applies to:

  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
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.
Modification Type:MajorLast Reviewed:11/24/2003
Keywords:kb3rdparty kbprb KB96122
©2003 Microsoft Corporation. All rights reserved.