- 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:
- The worksheet is reloaded.
- Under Options, RECALC is set to YES.
- 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,"")
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
- Move the cell pointer to the cell that contains the formula.
- 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.