Avoid recalculations
What is a recalculation?
Google Sheets automatically recalculates all formulas every few hours, even if your spreadsheet is not open or hasn't been edited. Actions like sorting data, moving cells, or simply opening the spreadsheet can also trigger recalculations. This applies to GPT formulas as well, which may lead to unexpected costs or overwritten results.
How to manage or avoid recalculations
To minimize the impact, you can:
Keep the cache enabled to store formula results.
Replace formulas with their results in selected cells or across an entire sheet.
Disable your GPT formulas to avoid new executions in your spreadsheet.
warning
Do not delete or move cells, or sort your sheet while formulas are loading.
Recalculation triggers
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 |