Microsoft KB Archive/20779

Multiplan: Cells Displayed Onscreen Recalculate First PSS ID Number: Q20779 Article last modified on 10-17-1990 PSS database name: D_MPlan

2.x 3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

If the “recalc” field is set to Yes, then the spreadsheet will be recalculated each time the contents of a cell change. Cells displayed on the screen are calculated first, then the offscreen cells are calculated.

In the case of onscreen formulas referencing offscreen formulas, the supporting formulas are calculated first. If a string formula is included in a group of cells that have been formatted to be continuous, and the first cell of that group is offscreen, then the formula may not be recalculated on screen. Check for “@[cont]” format and change it to another format if a cell is not being updated onscreen.

Copyright Microsoft Corporation 1990.