Skip to main content

Freeze Results

By default, GPT formulas like =GPT(), =GPTLIST(), and =GPTTABLE() are live functions. They re-run every time the sheet is opened or refreshed. This can lead to unnecessary API usage and increased costs, especially if the results don’t need to change.

When to Freeze:​

If you’re happy with the AI-generated content and no longer need it to update, you can freeze the result by converting the formula to static text. This stops further API calls and locks in the current output.

How to Freeze?​

  • Go to Extensions > GPT Mate for Sheets > Open App
  • In the GPT Mate sidebar, click the home icon and go to the Optimising GPT Mate section
  • Choose to convert GPT formulas to static values for Selected Cells or All Cells

Optimising GPT Mate

Replace formulas manually​

  • Select the cells that contain the formulas.
  • Press Ctrl+C and copy them
  • Paste the copied results by pressing Ctrl+Shift+V
  • Formulas within the manually selected cells are now replaced by their respective results.
info

Freezing results is highly recommended for finalised summaries, reports, or content shared with others, saving both performance and cost.

warning

This action is permanent. Once converted, the original formula is removed. If you want to regenerate or modify the content later, you will need to re-enter the GPT formula manually.