Refresh GPT formulas manually
Re-execute GPT formulas in selected cells, errors, or in the entire sheet to update results when inputs change, errors are fixed, or new outputs are needed.
Prerequisites
- You have opened a workbook containing GPT formulas.
- You have opened the GPT in Excel add-in from the Home tab.
Refresh formulas in selection
Open the GPT formulas controls dropdown.
- Check that the GPT formulas aren't paused for your workbook.
Select the cell(s) which contain formulas you want to refresh in the current sheet.
Click In selection in the Refresh GPT formulas section.
(optional) Pause the formulas again to prevent any further execution, in this sheet and the rest of the document.
GPT formulas within the selected cells are refreshed.
Refresh errors only
After troubleshooting GPT in Excel errrors, you can refresh all GPT formulas in cells tagged with #ERROR!
or #VALUE!
.
Open the GPT formulas controls dropdown.
- Check that the GPT formulas aren't paused for your workbook.
Click Errors only under the Refresh GPT formulas section.
(optional) Pause the formulas again to prevent any further execution, in this sheet and the rest of the document.
All GPT formulas that were on error in the current sheet are refreshed. If some errors persist, let us know by submitting a support request so we can assist you further.
Refresh formulas in current sheet
Open the GPT formulas controls dropdown.
- Check that the GPT formulas aren't paused for your workbook.
Click In sheet under the Refresh GPT formulas section.
(optional) Pause the formulas again to prevent any further execution, in this sheet and the rest of the document.
All GPT formulas in the current sheet are refreshed.