Select formula recalculation mode

By default, the automatic mode of formula recalculation is selected in the document.

To switch the mode, do one of the following:

1.Open the mode selection sub-menu in one of the following ways:

•On the Data tab, click Calculation mode with the image of the current calculation mode. For example, Calculation mode.

•When working in macOS, select Data > Calculation mode command from the command menu.

2.In the sub-menu that opens, select the desired formula recalculation mode: Calculate automatically / Automatically or Calculate manually / Manually.

The icon of the selected mode is displayed in the Status bar.