Skip to main content

Regenerate GPT formula results

Re-execute GPT formulas to update results in the selected cells.

Prerequisites
You have opened a Google spreadsheet containing GPT formulas and selected Extensions > GPT for Sheets and Docs > Open.
  1. In the GPT for Sheets sidebar, click Settings from the GPT functions tab.

  2. Check that the GPT formulas aren't paused and that caching is disabled for your workbook.


  3. Select cells manually or click active to select all cells with active GPT formulas. Ensure all cells generated by formulas like GPT_LIST are selected to prevent data loss. Hold CTRL/CMD to adjust the selection.

  4. Click Regenerate selection.

  5. (Optional) Pause the formulas to prevent recalculations in this sheet and the rest of the document.
GPT formula results within the selected cells are regenerated.

note

Working with selections larger than 10,000 cells may negatively impact performance. For best results, keep the number of GPT formulas on one sheet under 10,000.