Google Sheets manual calculation is here, and everyone on the file sees the old numbers

What is manual calculation in Google Sheets?

Some background first. Normally Sheets works out every formula again the moment something it depends on changes. Google calls this Automatic mode, and it is still the default. On a small sheet you never notice it, but on a file with tens of thousands of lookups, every edit starts a chain of recalculation and the sheet feels stuck.

Manual mode stops that chain. In Google’s own words, it “only calculates the document when you select Calculate at the top of the screen”. You turn it on in File, Settings, Calculation, under Calculation Mode, and the help page says a banner appears at the top to remind you that Manual Calculation Mode is on.

Google’s announcement of 21 September 2026 gives three reasons to use it. Pasting large blocks of data without a recalculation after every step, changing several inputs of a financial or forecasting model before you look at the result, and holding still the values of volatile functions like random numbers and timestamps. A volatile function is one that changes by itself, like RAND, which gives a new random number every time the sheet calculates.

Who sees old numbers when a Google Sheet is on manual?

Everyone who opens the file. This is the part that matters for a shared sheet. The calculation settings sit in a dialog that is literally titled “Settings for this spreadsheet”, next to the locale and time zone, and Google’s help page says that when you make a change there, it changes for the entire spreadsheet and everyone working on it will see the changes.

Then there is the tip at the bottom of the same page: “Manual calculation is only available for Sheet Editors and is not available in the Sheets mobile app.” Put those two lines together. An editor on a laptop sees the banner and can click Calculate. A person with view or comment access can open the file but cannot calculate it. And anyone reading the sheet in the phone app is in the same position, whatever access they have.

Here is how that goes wrong in real work. A sales team shares one tracker. On Monday morning the person who maintains it switches it to Manual to paste in last week’s export, gets pulled into a call, and never clicks Calculate. The regional manager opens the tracker on their phone before a meeting and reads last week’s totals, and there is nothing in the phone app they can press to get the new ones.

The same risk applies to anything that reads the numbers. I would expect the value an editor sees and the value an export or another report picks up to be the last calculated one, but Google does not say this directly, so check it on your own files before you rely on it.

How is Google Sheets manual calculation different from Excel?

If you come from Excel, the idea is familiar but the scope is the opposite. In the Excel desktop app the calculation mode belongs to your Excel session, not to one file. Microsoft’s page How Excel determines the current mode of calculation explains that the first workbook you open sets the mode, and every workbook you open after it uses that same mode.

That is why an Excel file can be on Manual without you touching anything, which I covered in why Copilot in Excel stops working on a Manual workbook. But it only affects you. Your colleague opening the same file on their own PC gets whatever mode their first workbook set. In Google Sheets there is one live copy of the file, so one person’s setting is everyone’s setting.

The banner is actually a point in Google’s favour. In Excel the only clue is often a small Calculate word in the status bar, and people miss it for days. So Sheets makes a paused file more visible, but it also lets the pause reach more people.

Why can't I find manual calculation in Google Sheets?

There are two reasons, and the second one confuses a lot of people. The first is the rollout. Google started it on 21 September 2026 and allows up to 15 days for the setting to show up, so some accounts will not see it until early October. The announcement lists Google Workspace customers and Workspace Individual subscribers. It does not mention free personal Google accounts.

I checked on my own personal Google account on 29 September 2026. The Calculation tab was there, but it held only two settings, Recalculation and Iterative calculation, and no Calculation Mode. So on that account, on that day, there was no manual calculation.

The second reason is the old Recalculation setting on the same tab. Its choices are On change, On change and every minute, and On change and every hour, and people see it and think they have found the switch, but they have not. The dialog itself says it “affects how often NOW, TODAY, RAND, and RANDBETWEEN are updated”, and it cannot stop any other formula from calculating.

The same is true for scripts. The Apps Script setting behind it, RecalculationInterval, lists only ON_CHANGE, MINUTE and HOUR on 29 September 2026. So if you were hoping to switch a file to Manual from an Apps Script automation, before a big import, the documentation does not offer that yet.

How do you pause a formula in Google Sheets without manual calculation?

If you do not have the new setting, or you only want to hold a few cells still, there is an older trick that works on any account. You put a switch in one cell and write the formula so that when the switch is off, the cell simply returns its own last value.

It needs one setting first. A formula that refers to its own cell is a circular reference, and Sheets shows a circular dependency error unless you turn on Iterative calculation in File, Settings, Calculation. Then put TRUE in A1 and write the formula in B1 as =IF($A$1,RAND(),B1). When A1 is TRUE the formula calculates. When A1 is FALSE, it gives back B1, which is whatever B1 already showed.

I tested this on a new sheet on 29 September 2026, with a plain =RAND() in C1 to compare. With A1 set to FALSE, C1 changed on every edit, from 0.4951 to 0.7448, while B1 stayed at 0.0375 the whole time. When I set A1 back to TRUE, B1 calculated again. I read the values from the saved file, not from my screen, so this is what anyone opening the file gets.

This works, except for three things. Iterative calculation is a file setting too, so it applies to every formula in the sheet, and it can hide a circular reference you made by mistake, the kind of silent error I look for in my checks on AI-made spreadsheet numbers. You have to wrap each formula you want to pause, one by one. And unlike manual calculation, there is no banner, so write a clear label next to the switch.

How do you use manual calculation without giving people old numbers?

The setting is useful, and I would use it on any heavy model once it reaches my account. The risk is only in forgetting it. These are the habits I would set for a team before anyone turns it on.

1. 01
   Pause, edit, calculate, switch back

   Treat Manual as a short state for one editing session, not a way of life for the file. When you finish, click Calculate and set the mode back to Automatic.
2. 02
   Never leave a shared report on Manual

   Viewers and phone readers cannot calculate, so a report people read on the go must stay on Automatic.
3. 03
   Look for the banner before you quote a number

   If the Manual Calculation Mode banner is showing, the numbers are from the last Calculate, not from now.
4. 04
   Split the heavy part out

   If a file is so slow that people want it on Manual all the time, the raw data probably belongs in its own file, and the shared summary can stay on Automatic.

That last habit is really about size. A file slow enough to need Manual is often close to the limits I went through in the Google Sheets 20 million cell limit, and splitting it helps with both problems at once. The AI functions in Google Sheets AI functions also work better on a tidy summary than on a heavy raw tab.