XL: Formulas in Imported Works File Not Calculated Correctly

ID: Q118936

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 5.0c
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel 97 for Windows
Microsoft Works for Windows, version 3.0

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. Thus, when a cell containing a formula is referred by another cell, it may return an error value such as #NAME.

WORKAROUNDS

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).

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:

Q112447 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


Keywords          : xlloadsave 
Version           : 4.00 4.00a 5.00 5.00c 7.00 7.00a
Platform          : WINDOWS 
Issue type        :

Last Reviewed: July 23, 1999