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.

   

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

   

3. Select cells manually or click on active to select all cells in the current sheet that contain active GPT formulas. To adjust the selection, hold down the CTRL/CMD key while clicking on cells to deselect them.

   
   Warning

   Always select the full range of results for functions like GPT_LIST to prevent data loss.

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.