New manual calculation setting in Google Sheets

We’re introducing a new manual calculation setting in Google Sheets to give you precise control over when formulas and other references update. The new manual calculation setting allows editors of complex or data-dense spreadsheets to pause automatic recalculation, batch their edits, and trigger a sheet-wide update at the exact moment they are ready to review the results.

Manual calculation offers users of especially complex Sheets a more streamlined, uninterrupted workspace for advanced analytical workflows. This feature is particularly useful for things like:

  • Uninterrupted high-volume updates: When pasting or modifying large blocks of data in spreadsheets  containing extensive formula networks (such as multi-sheet lookups and aggregations), you can enter all updates smoothly without intermediate recalculations running after every action.
  • Structured scenario modeling: When adjusting multiple assumption drivers in financial or forecasting models, you can input your variables sequentially and recalculate once. This ensures you only view the complete, final state of the scenario rather than partial, intermediate calculations.
  • Stabilizing volatile simulations: For spreadsheets utilizing volatile functions (such as random generators or live timestamps), manual calculation lets you freeze the data state so your numbers remain stable while you analyze results or present insights to key stakeholders.

Enabling Manual Calculation Mode


Controlling when Sheets calculates

Getting started

  • Admins:  There is no admin control for this feature.
  • End users: This feature will be OFF by default and can be enabled by the user by navigating to File > Settings > Calculation Settings in their Sheet. Visit the Help Center to learn more.

Rollout pace

Availability

  • Available to all Google Workspace customers and Workspace Individual subscribers

Resources