Microsoft KB Archive/69204

= Works: Converting from Lotus 1-2-3 Release 3 to Works =

Article ID: 69204

Article Last Modified on 11/16/2006

-

APPLIES TO


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

-



This article was previously published under Q69204



SUMMARY
Works uses Lotus 1-2-3 Release 2 format. Lotus 1-2-3 Release 3 has a translation utility that enables you to convert Works files to Lotus Release 2 format. This program does not translate the formulas that are new to Release 3 or that are linked to another file.



MORE INFORMATION
The new formulas in Release 3 are as follows.  Database Date  Logical  Special  Statistic  Financial  Mathematical -

@DGET    @D360 @ISRANGE  @COORD   @STDS      @VDB       @SUMPRODUCT @DQUERY                  @INFO    @VARS @DSTDS                   @SHEETS @DVARS The Lotus translation program provides the option to save the Release 3 formulas as labels or add-ins. If saved as add-ins, the Release 3 formulas appear as &quot;ERR.&quot;

If saved as labels, the Release 3 formulas appear in Works as text for all versions of Works for MS-DOS and Works for Windows.

Works 2.0 for Windows
If saved as add-ins, the Release 3 formulas appear as

Formula ignored: not valid:. Continue to display errors?&quot;

Works 2.0 may not display &quot;ERR;&quot; instead it may display an incorrect or very large number.

Works 3.0 for Windows
If saved as add-ins, the Release 3 formulas appear as

Formula ignored. Continue to display errors? While opening the file, Works found a formula that was too long, too complex, or contained a function which is not supported.&quot;

Works 3.0 will display &quot;ERR.&quot;

Works 4.0, 4.5, and 4.5a for Windows 95
If saved as add-ins, the Release 3 formulas appear as

Problem with formula. The formula is too long or too complex, or contains a function that is not supported.

Works 4.0, 4.5, and 4.5a for Windows 95 will display &quot;ERR.&quot;

Additional query words: 2.00 3.00 4.00 4.00a 4.50 4.50a lotus lotus123

Keywords: kb3rdparty kberrmsg kbinfo KB69204

-

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

© Microsoft Corporation. All rights reserved.