Evidence-linked product lifecycle intelligenceSUPPORT · SECURITY · RETIREMENT
← Lifecycle catalogue
SERVICE UPDATEGOOGLEVERIFIED

PUBLISHER UPDATE · GOOGLE-WORKSPACE-AD6892938D43B3E2

GOOGLE-WORKSPACE-AD6892938D43B3E2 release notes and known issues

New manual calculation setting in Google Sheets

Scope: Google Workspace. This update record adds version, fix and known-issue context. Its publication date is not a lifecycle boundary.

Summary

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

Improvements and security content

  • 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

Known issues

Publisher statement

Not stated. The verified publisher record does not contain a known-issues statement.

Affected products and versions

Products

  • Google Workspace

Affected versions

  • See the official publisher source for applicability.

Fixed versions or updates

  • No fixed version is stated in this record.

Recommended action

Review the official publisher document before deployment.

Official publisher evidence

GOOGLEVERIFIED

New manual calculation setting in Google Sheets

Checked 4 Oct 2026. BlackTree preserves the last verified facts if a later source check is temporarily unavailable.

Open the official publisher source