How to Change Calculation Settings in Google Sheets (Including Iterative Calculation)

To change calculation settings in Google Sheets, click File > Settings, open the Calculation tab, choose Automatic or Manual under Calculation Mode, turn on Iterative calculation if a formula needs to use its own result, and click Save settings.

These steps are for Google Sheets in a web browser on a computer, and follow Google’s location and calculation settings help page. You need edit access to the file. The settings apply to the whole spreadsheet, so everyone who opens it gets the same behavior.

How to Change Recalculation Settings in Google Sheets

  1. Open the spreadsheet in Google Sheets on a computer.
  2. Click File in the menu bar, then click Settings. The Settings for this spreadsheet window opens on the General tab.
  3. Click the Calculation tab.
  4. Under Calculation Mode, choose Automatic or Manual.
  5. Click Save settings. The window closes.
Google Sheets Settings window on the Calculation tab with Calculation Mode and Iterative calculation options
Pick Automatic or Manual under Calculation Mode, then click Save settings.

If you picked Manual, a banner at the top of the sheet reminds you that Manual Calculation Mode is on. To switch back, repeat the steps and choose Automatic.

Automatic vs. Manual Calculation

  • Automatic is the normal setting. Sheets applies changes as soon as you do something in the spreadsheet.
  • Manual waits until you click Calculate at the top of the screen. That helps with a large or formula-heavy file, because you can make many edits and recalculate once instead of waiting after every change.

Manual calculation is only available to editors and isn’t available in the Sheets mobile app. Google began rolling out the Manual option in late September 2026, so it can take a little time to appear in every account.

A change only triggers a recalculation when other tabs, cells, or formulas refer to the cell you edited. Typing a number in a cell that nothing points to doesn’t recalculate anything.

If You See a Recalculation Menu Instead

Older versions of the Calculation tab, and many older guides, show a Recalculation menu with On change, On change and every minute, and On change and every hour. If your Calculation tab still looks like that, choose On change for normal use. Pick one of the timed options only when you want volatile functions to refresh on a clock while the file is open.

Volatile Functions

Google calls TODAY, NOW, RAND, and RANDBETWEEN volatile functions because their values keep changing. TODAY changes every day, NOW every second, and RAND or RANDBETWEEN produce a new number each time the sheet recalculates. If a sheet full of random numbers keeps reshuffling while you work, Manual mode lets you decide when they update. If NOW or TODAY shows the wrong date or time, check Time zone on the General tab of the same Settings window.

How to Enable Iterative Calculation

Sheets normally refuses to calculate a formula that refers back to its own cell, directly or through other cells, and shows a “Circular dependency detected” error. Iterative calculation tells Sheets to run that loop a limited number of times instead.

  1. Click File > Settings and open the Calculation tab.
  2. Turn on Iterative calculation.
  3. Set Max number of iterations, which is how many times Sheets repeats the loop. A common starting value is 50.
  4. Set Convergence threshold. Sheets stops early when two passes in a row differ by less than this number. A common starting value is 0.05.
  5. Click Save settings.
How to turn on iterative calculation in Google Sheets
Illustration: how to turn on iterative calculation in Google Sheets.

The circular dependency error goes away, and the cell shows the value Sheets reached when it stopped.

A Worked Example

Say an order total includes a 2% fee charged on the total itself. Type 1000 in B1 for the order, enter =B3*0.02 in B2 for the fee, and enter =B1+B2 in B3 for the total. B2 and B3 depend on each other, so Sheets shows the circular dependency error. With iterative calculation on, Sheets repeats the loop and settles at about 1020.41 in B3.

The same answer comes from a formula with no loop: =B1/(1-0.02). When you can rewrite a circular formula like this, do it, because the result is exact and the sheet calculates faster.

Should You Turn It On?

Iterative calculation hides the error but keeps the loop. If the circular reference was an accident, such as a SUM that includes its own cell, fix the formula instead. Turn the setting on when the loop is deliberate, like interest on a revolving balance.

If the result changes every time the sheet recalculates, raise the maximum iterations or lower the threshold. The sheet calculates more slowly, but it’s more likely to settle on a stable answer. Rounding intermediate results with ROUND, or wrapping a division in IFERROR, can also stop a loop from bouncing between values.

How Often Import Functions Update

Functions that pull in outside data follow their own schedule, whatever calculation mode you choose. Those schedules are:

  • IMPORTRANGE: every 30 minutes.
  • IMPORTHTML, IMPORTFEED, IMPORTDATA, and IMPORTXML: every hour.
  • GOOGLEFINANCE: may be delayed up to 20 minutes.

Sheets Calculation Questions

Why isn’t my Google Sheet updating its formulas?

Check File > Settings > Calculation. If Calculation Mode is Manual, click Calculate at the top or switch back to Automatic. Import functions refresh on their own schedules, so their results can lag by up to an hour. If a cell shows the formula text instead of a result, formulas may be set to show in place of their values.

Can I change calculation settings in the Sheets app on my phone?

Manual calculation isn’t available in the Sheets mobile app. Make the change on a computer, and the setting applies when you open the file anywhere.

Will other people see my calculation settings?

Yes. These settings apply to the entire spreadsheet for everyone working on it. The Locale setting on the General tab works the same way, which matters if you use currency formatting or date formats that depend on the region.

Does turning off autocomplete stop formulas from calculating?

No. Autocomplete only controls suggestions while you type. To stop those, use the autocomplete and suggestion controls instead.