Manage cache in your workbook
Cache the results of your GPT formulas to minimize costs by reusing previous results, or disable caching to generate diverse results.
Prerequisites
- You have opened a workbook containing GPT formulas.
- You have opened the GPT for Excel add-in from the Home tab.
Enable cache to save costs and reuse previous results
You can enable cache usage to avoid being charged for using the same formula frequently. This mode ensures that results for the same formulas are retrieved from the cache instead of resulting from new API calls.
Open the GPT formulas controls drowpdown.
Click on the Enable cache switch to start saving results.
Caching is enabled for GPT formula results in your workbook. You can now save costs and reuse all future results of your GPT formulas.
Disable cache to get varied results to the same formula
If you want to quickly experiment and receive different results for the same formula (for example: dragging a formula), you can disable cache usage. This mode allows for dynamic and varied results from GPT, but incurs additional costs for each execution of the same formula.
Open the GPT formulas controls drowpdown.
Click on the Enable cache switch to get varied results from your GPT formulas.
Caching is disabled for GPT formula results in your workbook. Each time the formulas are reloaded, they will be executed again, incur costs, and may return new results.