Retry formulas on error
After troubleshooting GPT for Excel errors, you can recalculate all GPT formulas in cells tagged with #ERROR!
or #VALUE!
.
Prerequisites
You have opened an Excel workbook containing GPT formulas and clicked GPT for Excel Word in the Home tab.
Open the GPT functions tab in the GPT for Excel sidebar.
Check that the GPT formulas aren't disabled for your workbook.
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.