# Select a model for GPT functions in Excel

[GPT for Excel – Autosheet](https://autosheet.com/docs/gpt-for-excel) supports a [range of models](https://autosheet.com/docs/resources/models/ai-providers-and-models) that you can use with the [GPT functions](https://autosheet.com/docs/gpt-for-excel/gpt-functions). To help you find the model that offers the best balance of accuracy, speed, and cost for your use case, see our [recommended models](https://autosheet.com/docs/resources/models/recommended-models).

The available models depend on:

- **The API keys set for your current space.** Autosheet gives you access to a default set of built-in models. To access additional models, [set an API key for one or more AI providers](https://autosheet.com/docs/gpt-for-excel/setup/manage-models/manage-api-keys).
- **The API endpoints set up for your current space.** To access even more models, set up a connection to an [Azure OpenAI API endpoint](https://autosheet.com/docs/gpt-for-excel/setup/manage-models/connect-to-azure-openai) or any [OpenAI-compatible API endpoint](https://autosheet.com/docs/gpt-for-excel/setup/manage-models/connect-to-api-endpoints).
- **The model settings for your current space.** Space owners and admins can [control which models are available in Autosheet](https://autosheet.com/docs/admin/ai-configuration/manage-models?platform=microsoft).

## Recommended models

For information about recommended bulk models, see [Recommended models](https://autosheet.com/docs/resources/models/recommended-models#bulk-models).

## Select a built-in model

1. Open a Microsoft Excel workbook.

2. On the [ribbon](https://support.microsoft.com/en-US/Office/foundations-experiences/show-or-hide-the-ribbon-in-office), select **Home > GPT for Excel Word – Autosheet**.

   ![GPT for Excel Word – Autosheet on the Home ribbon](https://autosheet.com/docs/article-images/gpt-for-excel/launch.png)

   > **Info**
   >
   > If **GPT for Excel Word – Autosheet** is not visible on the ribbon, or if it's grayed out, select **Home > Add-ins > My Add-ins > GPT for Excel Word – Autosheet**. [Learn more.](https://autosheet.com/docs/gpt-for-excel/troubleshooting/add-in-not-working#add-in-button-is-grayed-out)

3. In the sidebar, select **GPT functions**.

4. Expand **Model settings** and open the model switcher.

   ![Open the model switcher](https://autosheet.com/docs/article-images/gpt-for-excel/model-settings-switcher-functions.png)

5. Under **Built-in models**, select a model.

   ![Select a model](https://autosheet.com/docs/article-images/gpt-for-excel/model-switcher-tk.png)

GPT for Excel – Autosheet now uses the selected model to generate responses for GPT functions.

> **Info**
>
> - When [cache](https://autosheet.com/docs/gpt-for-excel/gpt-functions/manage-gpt-formulas/manage-cache) is enabled, existing GPT formulas will not automatically update to the new model when you re-execute them.
>
>   To re-execute an existing formula with the new model:
>
>   1. [Set the model as a parameter in the formula.](https://autosheet.com/docs/gpt-for-excel/gpt-functions/reference#temperature-and-model)
>   2. Press Enter to re-execute the formula.
>
> - The [GPT_MATCH](https://autosheet.com/docs/gpt-for-excel/gpt-functions/reference#gpt_match-function) function uses `text-embedding-ada-002`, not the model you select.
>
> - The [GPT_WEB](https://autosheet.com/docs/gpt-for-excel/gpt-functions/reference#gpt_web-function) function uses the [web search model set for your space](https://autosheet.com/docs/admin/ai-configuration/manage-models#set-the-default-bulk-models).

## Select a connected model

**Prerequisites**

- You have [set an API key](https://autosheet.com/docs/gpt-for-excel/setup/manage-models/manage-api-keys) for the AI provider whose model you want to use.
- If you want to use an Azure model or an OpenAI-compatible model from an API endpoint, you have set up the [correct endpoint](https://autosheet.com/docs/gpt-for-excel/setup/manage-models).

1. Open a Microsoft Excel workbook.

2. On the [ribbon](https://support.microsoft.com/en-US/Office/foundations-experiences/show-or-hide-the-ribbon-in-office), select **Home > GPT for Excel Word – Autosheet**.

   ![GPT for Excel Word – Autosheet on the Home ribbon](https://autosheet.com/docs/article-images/gpt-for-excel/launch.png)

   > **Info**
   >
   > If **GPT for Excel Word – Autosheet** is not visible on the ribbon, or if it's grayed out, select **Home > Add-ins > My Add-ins > GPT for Excel Word – Autosheet**. [Learn more.](https://autosheet.com/docs/gpt-for-excel/troubleshooting/add-in-not-working#add-in-button-is-grayed-out)

3. In the sidebar, select **GPT functions**.

4. Expand **Model settings** and open the model switcher.

   ![Open the model switcher](https://autosheet.com/docs/article-images/gpt-for-excel/model-settings-switcher-functions.png)

5. Under **Connected models**, select a model.

   ![Select a model](https://autosheet.com/docs/article-images/gpt-for-excel/model-switcher-byok.png)

GPT for Excel – Autosheet now uses the selected model to generate responses for GPT functions.

> **Info**
>
> - When [cache](https://autosheet.com/docs/gpt-for-excel/gpt-functions/manage-gpt-formulas/manage-cache) is enabled, existing GPT formulas will not automatically update to the new model when you re-execute them.
>
>   To re-execute an existing formula with the new model:
>
>   1. [Set the model as a parameter in the formula.](https://autosheet.com/docs/gpt-for-excel/gpt-functions/reference#temperature-and-model)
>   2. Press Enter to re-execute the formula.
>
> - The [GPT_MATCH](https://autosheet.com/docs/gpt-for-excel/gpt-functions/reference#gpt_match-function) function uses `text-embedding-ada-002`, not the model you select.
>
> - The [GPT_WEB](https://autosheet.com/docs/gpt-for-excel/gpt-functions/reference#gpt_web-function) function uses the [web search model set for your space](https://autosheet.com/docs/admin/ai-configuration/manage-models#set-the-default-bulk-models).

## What's next

Learn more about models:

- [AI providers and models supported by Autosheet](https://autosheet.com/docs/resources/models/ai-providers-and-models)
- [LiveBench (a good model benchmark)](https://livebench.ai/)