Avoid GPT formula recalculation in Sheets
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.
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 gets recalculated |
|---|---|
Google Sheets automatically refreshes the spreadsheet every few hours | All formulas on the sheet |
Open the spreadsheet (particularly if not accessed recently) | Potentially all formulas on the sheet |
Insert, move, or delete a column | Formulas in subsequent columns |
Insert, move, or delete a row | Formulas in subsequent rows |
Sort rows | Formulas in rows that were moved |
Move a formula to a different cell | Moved formula |
Undo the deletion of a formula from a cell | Restored formula |