Retry formulas on error

After troubleshooting GPT for Sheets errors, you can recalculate all GPT formulas in cells tagged with #ERROR! or #VALUE!.

Prerequisites

You have opened a Google spreadsheet containing GPT formulas and selected Extensions > GPT for Sheets and Docs > Open.

1. Check that the GPT formulas aren't disabled for your spreadsheet.

   Note: To highlight the errors, click on X errors. This will help you identify the GPT formulas that need correction.

2. Click Retry errors.

   

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

What's next

Replace GPT formulas with their results in the selected cells to prevent any further recalculation.