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.