Microsoft KB Archive/22154

Recalculation Will Not Occur with Protected Sheets PSS ID Number: Q22154 Article last modified on 01-13-1989 PSS database name: D_MPlan

3.00 3.01 3.02

MS-DOS

Problem: If recalculation is off, saving the worksheet is supposed to force a recalculation. But if the Protection option is chosen (Protected: yes), the worksheet is not recalculated when it is saved. Furthermore, after the spreadsheet is reloaded with the correct password, the cells will not recalculate, even if Recalc is set to Yes or if the Recalc key is pressed.

Response: The only way to recalculate at this point is to highlight the cells that need to be recalculated and press edit (the ENTER key). Microsoft has confirmed this to be a problem in Versions 3.00, 3.01, and 3.02. This problem was corrected in Multiplan Version 3.04.

Copyright Microsoft Corporation 1989.