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

use the Formulas Control menu to freeze or refresh a GPT Formula in Google Sheets

Click on refresh all or refresh range if you have many cells

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