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

Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 21, 2026

Availability

Available to all Google Workspace customers and Workspace Individual subscribers

Resources

Google Help: Set a spreadsheet’s location & calculation settings

Google Sheets has introduced a new manual calculation setting designed to give you precise control over when formulas and references update. Launched on September 21, 2026, this feature allows editors of complex, data-heavy spreadsheets to pause automatic recalculations, batch their edits, and trigger updates only when they are ready. [1, 2]

🛠️ How to Enable Manual Calculation

The feature is OFF by default and must be turned on per spreadsheet. It applies to the entire spreadsheet, meaning changes will affect all collaborators working on that file. [1, 3, 4]

To turn it on:

Open your spreadsheet on a computer (it is not available on the Sheets mobile app).
Click File > Settings > Calculation.
Under Calculation Mode, switch the dropdown from “Automatic” to Manual.
Click Save settings.
When you are ready to update your data, click the Calculate button that appears at the top of the screen. [2, 3, 5]

🌟 Why Use It?

This feature eliminates the “loading lag” common in enterprise-level spreadsheets. It is highly beneficial for: [2]

High-Volume Data Dumps: You can paste massive blocks of data without the UI freezing up after every cell edit. [1, 2]
Financial Scenario Modeling: It lets you input multiple sequential assumptions and see the final, unified outcome rather than confusing, partial intermediate calculations. [1, 2]
Freezing Volatile Functions: It temporarily locks down values generated by random strings or live timestamps (NOW(), RAND()), ensuring numbers don’t jump around during presentations. [1, 2]

📅 Rollout and Availability

Eligible Users: All Google Workspace and Workspace Individual customers.
Rollout Pace: A gradual rollout began on September 21, 2026, for both Rapid Release and Scheduled Release domains, taking up to 15 days for feature visibility.
Admin Control: There is no admin setting for this; individual spreadsheet editors manage it directly. [1, 2]