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
- Replace formulas with their results automatically (currently reserved to GPT-4 and GPT-4 Turbo models and the GPT_WEB function)
- Replace GPT formulas with their results manually in selected cells or across an entire sheet
- 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. With Safe mode, you can delete loading formulas to prevent them from being executed. - 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 Trigger | What cells get recalculated |
---|---|
Google Sheets automatically reloads your spreadsheet every few hours | All GPT formulas |
Sorting data in your sheet | Only the relocated GPT formulas |
Undoing the deletion of a GPT formula from a cell | Only the restored GPT formula |
Moving a GPT formula to a different cell | Only the relocated GPT formula |
Adding or moving a row/column positioned before a cell containing GPT formulas | GPT formulas in subsequent rows/columns |
Opening the spreadsheet, particularly if it hasn't been accessed recently | Potentially all GPT formulas |