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 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 the Data > Calculation mode command from the command menu.
2.In the menu that opens, select the desired formula recalculation mode: Calculate automatically or Calculate manually.
The icon of the selected mode is displayed in the Status bar.