Google Sheets adds manual calculation for complex spreadsheets
By Automate Basics, written with AI from Google's original
Google has added a manual calculation setting to Sheets for people editing complex spreadsheets. Editors can pause automatic recalculation, make several changes, then update the sheet when they are ready to review the results.
What changed in Google Sheets
Google says a new manual calculation setting lets Sheets editors decide when formulas and other references update. Instead of recalculating as edits are made, a sheet can wait while someone changes a large block of data or adjusts several inputs. The editor can then trigger an update across the sheet to review the completed result.
Google points to spreadsheets with many connected formulas, including lookups across sheets and summaries, as a reason to use the setting. It also describes forecasting models where several assumptions need to change together. For sheets using random values or live timestamps, pausing recalculation can keep the current results steady during analysis or a presentation.
Who can use Google Sheets manual calculation?
Google says manual calculation is available to all Google Workspace customers and Workspace Individual subscribers. The setting is off by default, and users can enable it for a sheet themselves. Google says there is no administrator control for the feature.
The company began a gradual rollout on September 21, 2026, for both Rapid Release and Scheduled Release domains. Google says visibility of the feature can take up to 15 days, so an eligible user may not see it immediately. The announcement does not give a separate price for manual calculation or say whether it is available outside the listed Workspace subscriptions.
How do I try manual calculation at work?
Google says editors can enable manual calculation in a sheet through File > Settings > Calculation Settings. A sensible first trial is a spreadsheet where you regularly change several forecasting assumptions or paste a large batch of data before checking the outcome. Make the related edits, then trigger the sheet-wide update when you are ready to review the completed results.
Check the formulas and summaries you rely on after recalculating, particularly if other people will use the sheet for a decision. Remember that the point of pausing recalculation is to keep intermediate results from updating. Until you request an update, the figures on display may not reflect your latest edits.
Frequently asked questions
Does manual calculation turn on automatically in Google Sheets?
No. Google says manual calculation is off by default. An editor can enable it for a sheet through File > Settings > Calculation Settings. The setting lets them make changes without automatic recalculation and update the sheet when they are ready.
Do Workspace administrators need to enable manual calculation?
No. Google says there is no administrator control for manual calculation. Eligible users can turn it on themselves in a sheet. The feature is rolling out gradually to Google Workspace customers and Workspace Individual subscribers, so it may not be visible to everyone yet.
Related reading
n8n details how to test prompt changes inside AI workflowsn8n has published guidance on using its Evaluations feature to test prompt changes within an existing workflow. Teams can run the same examples through different prompt versions, score the outputs and check for problems before updating a live process.
Google Sheets adds manual ordering for pivot table rows and columnsGoogle says Sheets users can now drag pivot table rows and columns into a custom order. The change helps people preparing reports match a business hierarchy instead of relying on alphabetical order.
Google Chat adds Confluence page previews and updatesGoogle says its new Confluence integration brings page previews and notifications into Google Chat. It is available to Google Workspace customers and personal Google account users who have a Confluence Cloud account.
Written with AI from Google's original and published after automatic checks: every figure here appears in the original, and no sentence is copied from it. The picture is AI-generated. The original is the authority.
Source: New manual calculation setting in Google Sheets, Google, 21 Sept 2026.