All calculations of all worksheets are automatically kept up to date. Whenever you change the content of a cell, PlanMaker recalculates the entire workbook.
Thus, you usually don't have to concern yourself with this issue at all.
Disabling automatic updating
If necessary, you can also disable the automatic updating of all worksheets. This can be useful if, for example, you want to edit a complex workbook on a slow device.
For this purpose, change the setting of the Recalc automatically option for the document properties accordingly.
| 1. | Choose the ribbon tab Formula | group Update | Recalculate  and click on the arrow of the icon to open its menu. |
| Alternatively: On the ribbon tab File | group File management | Recalculate or also in the Document properties, Calculate tab. |
| 2. | Remove the check mark in front of Recalc automatically to disable it. |
From now on, the Recalc only before ... setting is enabled:
There will be an automatic recalculation of the worksheets only when saving or printing the document, or when copying (or cutting) cells – depending on which option(s) you choose here. If all three options are disabled, calculations will no longer be updated automatically.
Starting recalculation manually
Even if you have disabled the automatic recalculation, you can still update the worksheets manually at any time. For this purpose, you can use the following keys or ribbon commands:
▪If you press the F9 key or choose the ribbon command Recalculate | Recalculate workbook, PlanMaker updates the calculations on all worksheets.
| Tip: This is also triggered if you simply click on the Recalculate icon directly. |
▪On the other hand, if you press Shift+F9 or choose the ribbon command Recalculate | Recalculate sheet, PlanMaker only updates the calculations on the current worksheet.
Note: The latter can return outdated results if the current worksheet performs calculations with cells in other worksheets.
Updating external cell references
Note that external cell references are not updated every time you recalculate the workbook.
(External cell references are cell references that refer to cells in another workbook – for example ='C:\My Folder\[My Workbook.pmdx]Sheet1'!A1.)
Such cell references are automatically updated only when you open the document that contains the external references. You can also manually update external references at any time.
For more information on working with external references, see External cell references.
Additional notes
For information on updating charts or pivot tables, please see the relevant sections Updating charts and Updating pivot tables and changing data area.