Microsoft KB Archive/118936

= Formulas in Imported Works File Not Calculated Correctly =

Article ID: 118936

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Works 3.0 Standard Edition

-



This article was previously published under Q118936



SYMPTOMS
If you create a spreadsheet in Microsoft Works version 3.0 and save it as a Microsoft Excel 4.0/5.0 worksheet, the worksheet may not be recalculated as expected: dependent formulas are not recalculated as expected and may return the #VALUE! error value, and cells that are dependent on other cells (that is, cells that refer to other cells) may not be recalculated automatically.

NOTE: This problem occurs even when calculation option is set to automatic and there are no circular references.

In addition, Microsoft Works files opened in Microsoft Excel may not contain the correct information for the formula type. For example, although a formula, such as =RAND, may return a numerical value, you may not be able to use it as an argument of a numerical parameter of a function. Therefore, when a cell containing a formula is referred by another cell, it may return an error value such as #NAME.



WORKAROUND
To update the formulas in Microsoft Excel, do any of the following:


 * After you open the data in a Microsoft Excel worksheet, you can manually edit and update the cells that were not recalculated correctly. To edit the cell, press the F2 key and then press ENTER (without changing the contents of the formula). -or-


 * To transfer a file from Microsoft Works to Microsoft Excel, save it as a Works for Windows 2.0 spreadsheet or a Lotus WK1 spreadsheet. Currently, you cannot open Microsoft Works 3.0 spreadsheets in Microsoft Excel versions 5.0, 7.0, or 97.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Works version 3.0. This problem has been corrected in Microsoft Works version 3.0a.



MORE INFORMATION
For additional information, please see the following article in the Microsoft Knowledge Base:

112447 Works 3.0 File Saved in Excel Format Returns #VALUE!

You can save a Microsoft Works 3.0 spreadsheet file as a Microsoft Excel 4.0 or 5.0 worksheet by choosing the Excel 4.0/5.0 format in the Microsoft Works Save As dialog box.

Additional query words: 4.00a 97 XL97 wks wk1 xls W_Works XL

Keywords: KB118936

-

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

© Microsoft Corporation. All rights reserved.