Refresh or Freeze GPT cells
Open the Formula Controls panel
To refresh or freeze the GPT cells in Google Sheets, open GPT Workspace (from the extension menu or the Chrome extension) then click Formulas Controls
Freeze formulas
To replace the formulas with their generated value, select the range of formulas you want to freeze and click Freeze range
If you want to freeze every formulas in the sheet, click on Freeze all
Please note that freezing a formulas is irreversible.
The value generated by the formula will replace the formula itself.
Refresh formulas
If you want to refresh a formula value to generate a new value, select the range of GPT formulas you want to refresh then click on Refresh range.
If you want to refresh all the formulas in the current sheet, select Refresh all
Last updated