By default, the automatic mode of formula recalculation is selected in the document.
To switch the mode, do one of the following:
1.On the Data tab, click Calculation mode with the image of the current calculation mode. For example,
Calculation mode.
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.