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 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 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.

    The Behavior bar allows you to select an action and type a prompt.
  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 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, but incurs additional costs for each execution of the same formula.

  1. In the GPT for Excel sidebar, click Settings.

  2. 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.