Microsoft KB Archive/65888


 * 1) VALUE! Appears After Reloading and Recalculating a Worksheet PSS ID Number: Q65888 Article last modified on 10-05-1990 PSS database name: D_MPlan

4.00 4.01 4.01a

MS-DOS

Summary:

In Multiplan versions 4.01 and 4.01a, the #VALUE! error will appear in a cell containing a formula that references an empty cell if all of the following conditions are met:


 * 1) The worksheet is reloaded.
 * 2) Under Options, RECALC is set to YES.
 * 3) Input from the user forces a recalculation of the worksheet.

For example, if cell R2C2 is empty, the #VALUE! will appear in the cell R2C3, which contains the following formula:

If(R2C2=“B”,R2C9,&quot;&quot;)

Multiplan version 4.20 does not exhibit this problem.

More Information:

The following are methods to work around this problem in Multiplan versions 4.01 and 4.01a:

Method 1

 * 1) Move the cell pointer to the cell that contains the formula.
 * 2) Press “E” for Edit and then press ENTER.

Note: This method must be repeated each time the worksheet is loaded.

Method 2
Create at least one blank space in the referenced cell.

Method 3
Always save and reload the file in SYMBOLIC format.

Copyright Microsoft Corporation 1990.