Microsoft KB Archive/20777

Multiplan: When Recalculation Occurs PSS ID Number: Q20777 Article last modified on 01-16-1991 PSS database name: D_MPlan

1.x 2.x 3.x 4.00 4.01 4.20

MS-DOS

Question:

When does recalculation take place?

Response:

SYLK files and spreadsheets that have external links are recalculated as soon as they are loaded. Most files are recalculated when they are saved, whether the recalc option is set to Yes or No, unless the worksheet has not been changed since it was last recalculated. If the recalc option is set to No, recalculation will occur if the recalculation key (F4) is pressed or if the spreadsheet is saved.

Versions 3.0, 3.01, and 3.02 also force a recalculation upon printing the spreadsheet, even if recalc is set to No.

Version 3.04 works the same as the 2.x versions in that it will not recalculate upon printing if recalc is set to No.

Copyright Microsoft Corporation 1991.