How can we help you?

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

Was this helpful?
Yes
No
Next
Sheets