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. 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.