Skip to main content

Manage cache in your workbook

Cache the results of your GPT formulas to minimize costs by reusing previous results, or disable caching to experiment with sidebar settings.

Prerequisites
You have created a Microsoft workbook and clicked GPT for Excel Word in the Home tab.

Enable cache to save costs and reuse previous results when reloading a formula​

You can enable cache usage to avoid being charged for reusing formulas. This mode ensures that results for the same formula are retrieved from the cache instead of generating new results.

  1. In the GPT for Excel sidebar, click Settings from the GPT functions tab.

  2. 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 experiment with sidebar settings​

If you want to quickly experiment with various settings, you can disable cache usage. Disabling your cache doesn’t clear its content. It stops storing new executions and fetching existing ones from it.

  1. (Optional) Replace GPT formulas with their results if you want to preserve the current results.

  2. In the GPT for Excel sidebar, click Settings from the GPT functions tab.

  3. Click on the Enable cache switch to put it in disabled state.

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.

On this page