Skip to main content

Avoid recalculations

Google Sheets automatically recalculates all formulas in the following cases:

  • If you move columns or rows around, or sort your rows
  • Automatically every few hours when you don’t touch your spreadsheet, even if it is not opened

This includes GPT formulas and can lead to unexpected costs and result loss. To minimize the impact, you can:

  • Replace your formulas
  • Use safe mode
    Store results inside formulas by enabling safe mode. This method is currently reserved to GPT-4 and GPT-4 Turbo models and the GPT_WEB function. It cannot handle more than 2000 executions launched in parallel.
  • Pause your formulas
    Pause your GPT formulas to avoid new executions in your spreadsheet
warning

Do not delete, move cells, or sort your sheet while formulas are loading.

What triggers formula recalculation

The following triggers cause your GPT formulas to recalculate in your spreadsheet:

Recalculation TriggerWhat cells get recalculated
Google Sheets automatically reloads your spreadsheet every few hoursAll GPT formulas
Sorting data in your sheetOnly the relocated GPT formulas
Undoing the deletion of a GPT formula from a cellOnly the restored GPT formula
Moving a GPT formula to a different cellOnly the relocated GPT formula
Adding or moving a row/column positioned before a cell containing GPT formulasGPT formulas in subsequent rows/columns
Opening the spreadsheet, particularly if it hasn't been accessed recentlyPotentially all GPT formulas