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 sidebar, select GPT functions, and click Model settings.

   

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

   

GPT for Excel uses the creativity level to generate all responses for GPT functions and bulk AI tools.

info

When cache is enabled, existing GPT formulas will not automatically update to the new creativity level when you re-execute them.

To re-execute an existing formula with the new creativity level:

1. Set the temperature parameter directly in the formula.

2. Press Enter to re-execute the formula.

What's next

• Run bulk AI tools and execute GPT functions in GPT for Excel.

• Configure other settings to customize how the language model operates.