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 ModeControlling when Sheets calculatesGetting startedAdmins: 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 paceRapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 21, 2026AvailabilityAvailable to all Google Workspace customers and Workspace Individual subscribersResourcesGoogle Help: Set a spreadsheet’s location & calculation settings