Skip to main content

Set the creativity level in GPT for Excel

Set the creativity level that will be used for all GPT for Excel operations in your workbook to define how standard (or not) your output is expected to be. You can find out more about the temperature setting, used by OpenAI to set a creativity level, in our Temperature guide.

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

  2. Use the slider to set Creativity between 0 and 1.

The creativity level you defined is now the default for all GPT function executions. New executions will use this creativity level.

info

Existing formulas will not automatically update to the new creativity level if the cache is enabled. To re-execute them with a new creativity level, you can either disable the cache, select the formulas and regenerate their results, or change a parameter in the formulas and press Enter.

What's next

Specify a different creativity level within a formula with the temperature parameter.

On this page