GPT Workspace
  • GPT Workspace
  • Get started: Add-on
  • Get started: Chrome Extension
  • Subscription
    • Manage my subscription
    • Team subscription
    • Downloading invoices
  • Pricing and Models
    • What is a credit?
    • AI Models
    • Pay per usage
  • Products
    • GPT for Google Sheets
      • Formulas
        • GPT formula
        • GPT_WEB formula
        • GPT_LIST formula
        • GPT_TABLE formula
        • GPT_IMAGE formula
        • GPT_TRANSLATE formula
        • GPT_COMPLETE formula
      • Default Model, Temperature and Output size for GPT Formulas
      • Refresh or Freeze GPT cells
    • GPT for Google Docs
    • GPT for Google Slides
    • GPT for Gmail
  • FAQ
    • How to change the language?
    • Internet Access with GPT?
    • How to launch the GPT Gmail and GPT Drive add-on
    • I can't find the add-on from the sidebar
    • I can't install the extension
    • Is GPT Workspace included with ChatGPT Plus or Enterprise?
    • How to uninstall GPT Workspace
    • Do custom assistants have any limitations?
  • Resources
    • Common Errors
    • Tutorials and Resources
    • Data and Privacy
Powered by GitBook
On this page
  • Open the Formula Controls panel
  • Freeze formulas
  • Refresh formulas
  1. Products
  2. GPT for Google Sheets

Refresh or Freeze GPT cells

PreviousDefault Model, Temperature and Output size for GPT FormulasNextGPT for Google Docs

Last updated 1 year ago

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

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