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
- Open the spreadsheet in Google Sheets on a computer.
- Click File in the menu bar, then click Settings. The Settings for this spreadsheet window opens on the General tab.
- Click the Calculation tab.
- Under Calculation Mode, choose Automatic or Manual.
- Click Save settings. The window closes.

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.
- Click File > Settings and open the Calculation tab.
- Turn on Iterative calculation.
- Set Max number of iterations, which is how many times Sheets repeats the loop. A common starting value is 50.
- 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.
- Click Save settings.

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.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.