<< Click to Display Table of Contents >> Updating sheets

The calculations in a document are kept up-to-date automatically. Whenever you change the content of a cell, PlanMaker recalculates the entire workbook.

So usually you don't have to care about this.

Deactivating automatic updating

As needed, you can disable the automatic updating of calculations. This can be useful when, for example, you want to edit a complex workbook on a slow device.

For this purpose, change the setting of the Recalculation option in the document properties accordingly. See Document properties, Calculate tab.

When automatic updating is disabled, the calculations in the table have to be updated manually. You can use the following shortcut keys or ribbon commands for this:

▪To update the calculations on all worksheets, press the F9 key or choose the ribbon command Formula | group Update | Update data | Update calculations.

▪To update the calculations only on the current worksheet, press the key combination Shift+F9.

Note: The latter can return outdated results in case the current worksheet contains calculations that refer to cells on other worksheets.

Updating external cell references

Please note that external cell references are not updated when a workbook is recalculated.

(External cell references are cell references that refer to cells located in a different workbook – for example ='C:\My Folder\[My Workbook.pmdx]Sheet1'!A1.)

Such cell references are updated automatically only once, when you open the document that contains them. Apart from that, you can update them manually whenever needed.

For more information on working with external references, see External cell references.