New manual calculation setting in Google Sheets

<p>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.</p><p>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:</p><p></p><ul style="text-align: left;"><li><b>Uninterrupted high-volume updates: </b>When pasting or modifying large blocks of data in spreadsheets&nbsp; containing extensive formula networks (such as multi-sheet lookups and aggregations), you can enter all updates smoothly without intermediate recalculations running after every action.</li><li><b>Structured scenario modeling: </b>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.</li><li><b>Stabilizing volatile simulations: </b>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.</li></ul><div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi01KEcuW1x-qtNaHCoVQCVkQMAm112S0aREtSq_MSXzQpzJfq3lANOKYY8Q_icDcfvinG-XLK1rfFOIYovjrt-joU0YntLDfEPP14GutbcTSyc0oIdC-Y20sbzTEMhxZZPYzX4hUqp7zRxVlAdkd5vl3iDZJz-E71Zzb_6a_7rL4_Sgnu9txiL0fOvHmI/s2048/New%20manual%20calculation%20setting%20in%20Google%20Sheets%20-%206884%20-%201.gif" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1121" data-original-width="2048" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi01KEcuW1x-qtNaHCoVQCVkQMAm112S0aREtSq_MSXzQpzJfq3lANOKYY8Q_icDcfvinG-XLK1rfFOIYovjrt-joU0YntLDfEPP14GutbcTSyc0oIdC-Y20sbzTEMhxZZPYzX4hUqp7zRxVlAdkd5vl3iDZJz-E71Zzb_6a_7rL4_Sgnu9txiL0fOvHmI/s1600/New%20manual%20calculation%20setting%20in%20Google%20Sheets%20-%206884%20-%201.gif" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><br />Enabling Manual Calculation Mode</td></tr></tbody></table><br /></div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM85ByZqsFhYnjX99LXVC-99-oD3ZWz-nl6s2N2B4yz-XfAjp2aWUcLbcvl2sq54yBqK3QQ_6pvw-iTvT_-ozQRiAfW-y7Z_Q7anR8r9hyphenhyphenDwcntqrDZtw1dX8gLvUcivfND9xzYupo5lNDDhANMktNN3Laa9c8068SJI96ycpTn-lKuSlgNU61t2r33dw/s2048/New%20manual%20calculation%20setting%20in%20Google%20Sheets%20-%206884%20-%202.gif" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1121" data-original-width="2048" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM85ByZqsFhYnjX99LXVC-99-oD3ZWz-nl6s2N2B4yz-XfAjp2aWUcLbcvl2sq54yBqK3QQ_6pvw-iTvT_-ozQRiAfW-y7Z_Q7anR8r9hyphenhyphenDwcntqrDZtw1dX8gLvUcivfND9xzYupo5lNDDhANMktNN3Laa9c8068SJI96ycpTn-lKuSlgNU61t2r33dw/s1600/New%20manual%20calculation%20setting%20in%20Google%20Sheets%20-%206884%20-%202.gif" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><br />Controlling when Sheets calculates</td></tr></tbody></table><p></p><h3 style="text-align: left;">Getting started</h3><p></p><ul style="text-align: left;"><li><b>Admins:&nbsp;</b> There is no admin control for this feature.</li><li><b>End users: </b>This feature will be OFF by default and can be enabled by the user by navigating to <b>File &gt; Settings &gt; Calculation Settings</b> in their Sheet. Visit the Help Center to <a href="https://support.google.com/docs/answer/58515" target="_blank">learn more</a>.</li></ul><p></p><h3 style="text-align: left;">Rollout pace</h3><p></p><ul style="text-align: left;"><li><a href="https://support.google.com/a/answer/172177" target="_blank">Rapid Release and Scheduled Release domains:</a> Gradual rollout (up to 15 days for feature visibility) starting on September 21, 2026</li></ul><p></p><h3 style="text-align: left;">Availability</h3><p></p><ul style="text-align: left;"><li>Available to all Google Workspace customers and Workspace Individual subscribers</li></ul><p></p><h3 style="text-align: left;">Resources</h3><p></p><ul style="text-align: left;"><li>Google Help: <a href="https://support.google.com/docs/answer/58515" target="_blank">Set a spreadsheet’s location &amp; calculation settings</a></li></ul><p></p>

Publication

Google Workspace Updates blog feed · Government/Regulator

Published

21st September 2026

Original report

workspaceupdates.googleblog.com

ProcIntel stores what the source published in its feed — a headline, a summary and a link. It does not store or reproduce the full article.