Microsoft KB Archive/123268

{|
 * width="100%"|

XL5: Formula in WK4 File Displays #VALUE! Error Value

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c

-

SYMPTOMS
In Microsoft Excel, when you open a Lotus 1-2-3 WK4 file, a cell on the worksheet may display the #VALUE! error value even though the formula contained in the cell is displayed correctly in the formula bar.

CAUSE
This behavior occurs when the formula is converted properly (displays the correct formula in the formula bar), but initially evaluates to the #VALUE! error value. For example, if your Lotus 1-2-3 WK4 file contains the following formula

  @@(A1:A1) where A1 contains the formula @@COORD(1,2,1,8)&" "&@@COORD(1,2,1,8) and cell A2 is blank, the cell that contains the formula displays the #VALUE! error value when you open the file in Microsoft Excel.

WORKAROUND
To display the correct value in a cell that displays the #VALUE! error value under the above conditions, use the appropriate method for your situation.

Method 1: To display the value in an individual cell, follow these steps:

 Select the cell that contains the formula that is displaying the #VALUE! error value. Press F2. Press ENTER.

Method 2: To display the value in multiple cells, follow these steps:

 Select the worksheet that contains the #VALUE! Error values. From the Edit menu, choose Replace. In the Find What box, type =. In the Replace With box, type =, and choose Replace All.</ol>

MORE INFORMATION
To open Lotus 1-2-3 WK4 files in Microsoft Excel, you must obtain the Lotus 1-2-3 WK4 File Converter. The Lotus 1-2-3 WK4 File Converter is available in application note WE1130 "Lotus 1-2-3 WK4 File Converter."

For more information about obtaining the Lotus 1-2-3 WK4 File Converter, please see the following article in the Microsoft Knowledge Base:

"Q122583 XL5: Lotus 1-2-3 Release 4 for Windows File Converter" Lotus 1-2-3 is manufactured by Lotus Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.