Regenerate GPT formula results

Re-execute GPT formulas to update results in selected cells, fix errors, or generate new results accross an entire sheet.

Prerequisites

You have opened a Microsoft workbook containing GPT formulas and clicked GPT for Excel Word in the Home tab.

Regenerate results in selected cells

1. In the GPT for Excel sidebar, click Settings.

   

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

   

3. Select cells manually in the current sheet that contain active GPT formulas.

   Warning

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

4. Choose In selection in the Regenerate dropdown.

   

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.

Regenerate results in cells on errors

After troubleshooting GPT for Excel errors, you can re-execute all GPT formulas in cells tagged with #ERROR! or #VALUE!.

1. Check that the GPT formulas aren't paused for your workbook.

   

2. Click Errors only in the Regenerate dropdown.

   

3. (Optional) Pause the formulas to prevent recalculations in this sheet and the rest of the document.

All GPT formula results that were on error in the current sheet are regenerated. If some errors persist, let us know by submitting a support request.

Regenerate results for all GPT formulas in the current sheet

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

   

2. Click In sheet in the Regenerate dropdown.

   

3. (Optional) Pause the formulas to prevent recalculations in this sheet and the rest of the document.

All GPT formula results in the current sheet are regenerated.