Skip to main content

GPT for Excel issues

This article addresses the most common problems that can be encountered while using GPT for Excel. We'll provide fixes and guidance for troubleshooting everything from common typos to API key issues.

Errors

Add-in not supported

This add-in is only supported with your Microsoft 365 subscription license and is not supported with your Office license.

The following table lists the minimum versions of Microsoft Excel supported by the GPT for Excel add-in, according to your version of Office.

Office on Windows
- Microsoft 365 subscription
- retail perpetual Office 2016 and later
Office on Windows
(volume-licensed perpetual)
Office on MacOffice on iPadOffice on the webOffice Online Server
Excel Version 2002 (Build 12527.20092)Excel 2021 Version 2108 (Build 12527.20092)Excel 16.35Not supportedSupportedNot supported

Invalid name

#NAME? Invalid Name Error. The formula contains unrecognized text.

Problem: The GPT functions aren't recognized by Excel.

Solutions
  • Check that GPT for Excel is installed on the current Microsoft account.
  • Click GPT for Excel Word in the Home tab to enable the GPT functions.
  • If the problem persists, try activating the add-in (the experience might be slightly different for Mac users):
    1. Click Add-ins in the Home tab.
    2. Click More Add-ins.
    3. Select GPT for Excel Word in the My Add-ins tab.
    4. Click Add.
    5. Click GPT for Excel Word in the Home tab and click Retry errors in GPT for Excel sidebar.
  • Use the add-in on the Web version of Excel (see supported versions).

Invalid parameter

Error: Invalid xxx parameter.

Problem: The error indicates a formatting issue or an unreadable parameter within the formula.

Solutions
  • Check that you have quotation marks around your prompt if it is not in a cell:
    =GPT("hello")
    =GPT(A1)
    ❌ =GPT(hello)
  • Check that your parameters are in the correct order. See the function list.
  • Check that all parameters (even optional ones) are added as empty when there is another parameter coming after them:
    GPT_TRANSLATE(A2, "french", , "Avoid passive voice")
  • Check that you are using the right parameter separator for your locale: , or ;?
  • Check that you are using the correct number format for temperature for your locale: 0.8 or 0,8?

Error in value

Error in Value. A value used in the formula is of the wrong data type.

Problem: Your formula can't be interpreted by OpenAI.

Solutions
  • Check that you have quotation marks around your prompt if it is not in a cell:
    =GPT("hello")
    =GPT(A1)
    ❌ =GPT(hello)
  • Check that your parameters are in the correct order. See the function list.
  • Check that all parameters (even optional ones) are added as empty when there is another parameter coming after them:
    GPT_TRANSLATE(A2, "french", , "Avoid passive voice")
  • Check that you are using the right parameter separator for your locale: , or ;?
  • Check that you are using the correct number format for temperature for your locale: 0.8 or 0,8?

Formula parse error

Problem: Your formula can't be interpreted by Microsoft Excel.

Solutions
  • Check that you have quotation marks around your prompt if it is not in a cell:
    =GPT("hello")
    =GPT(A1)
    ❌ =GPT(hello)
  • Check that your parameters are in the correct order. See the function list.
  • Check that all parameters (even optional ones) are added as empty when there is another parameter coming after them:
    GPT_TRANSLATE(A2, "french", , "Avoid passive voice")
  • Check that you are using the right parameter separator for your locale: , or ;?
  • Check that you are using the correct number format for temperature for your locale: 0.8 or 0,8?

Required parameter in GPT function

Please set required parameter in GPT_XX() function

Problem: One of the parameters in your GPT formula is required and hasn't been set.

Solution

Check which parameters are required for the GPT function you are using and adjust the formula as needed.

Your API key is too limited

Problem: If your OpenAI organization is using a free trial, the rate limits of your API key will be too low to be used in GPT for Excel.
Solutions

If you are not using an OpenAI free trial account

Check that your OpenAI organization is correctly set in GPT for Excel:

  1. Select API keys from GPT for Excel sidebar menu.
  2. Enter your OpenAI organization ID and select Save. This step is crucial if you are part of multiple organizations, as it ensures that billing for usage in GPT for Excel is attributed to the appropriate account.

    Important Note: To check if the organization you are using has remaining credits, follow these steps:

    1. Click on your user icon in the bottom left corner and select the appropriate organization.

    2. Go to Billing settings to check if you have remaining credits.

If you are using an OpenAI free trial account

  • Option 1: Continue without and API key.
    This option is suitable for immediate use and if using your API key is not a priority. Select Continue without API key to clear it from GPT for Excel. Learn more about billing.
  • Option 2: Buy OpenAI credits for increased API rate limits.
    1. Go to OpenAI billing settings.
    2. Add your payment details.
    3. Purchase OpenAI credits starting at $5 to upgrade your account from the Free tier to Tier 1. This change increases your rate limit from 3 to 3,500 requests per minute with the gpt-3.5-turbo model. Note that TPM (Tokens Per Minute) limitations still apply, and further tier progression is necessary for greater TPM access.
    4. Wait up to 30 minutes for the new API key limit to become active.

OpenAI API not working with your key

Problem: While your OpenAI API key is recognized as valid, it is not working due to one or more of the following reasons:

  • The OpenAI free trial period associated with your account has expired.
  • You haven't purchased OpenAI credits (if you're on a prepaid billing plan).
  • You haven't added a payment method to your OpenAI account (if you're on a legacy monthly billing plan).
  • Your default OpenAI organization isn't correctly set.
  • You have added a payment method or purchased OpenAI credits within the last 30 minutes and you still get this message.
Solutions
  1. Go to OpenAI billing settings.
  2. Add payment details.
  3. Purchase OpenAI credits.
  4. Go to API keys in GPT for Excel sidebar menu to ensure your OpenAI organization is correctly configured.
  5. Wait up to 30 minutes for your OpenAI API key to become active.
Solution for immediate use: If immediate use is needed and using your API key is not a priority, select Continue without API key to clear it from GPT for Excel. Learn more about billing.

Requests per day limit reached

You have reached your xxx requests per day limit for model xxx.

Problem: You have reached your limit of requests per day (RPD) for the selected model.

Solutions

Tokens per day limit reached

You have xxx / xxx tokens per day left for model xxx.

Problem: You have reached your limit of tokens per day (TPD) for the selected model.

Solutions

Problems

Error loading Add-Ins

Problem: GPT for Excel sidebar fails to load, or remains blank.
Solution
Restart Excel, create a new workbook and launch the add-in again by clicking GPT for Excel Word in the Home tab.

The costs are too high

Problem: Your consumption is higher than you expected and you wish to spend less money on GPT function executions.

Solutions

I want to uninstall

Problem: You are not using the add-in in Excel or Word, and you want to uninstall it.
Solution
To remove the add-in from Excel and Word, follow the steps described in our uninstallation article.

I can't sign in after installing

Problem: You have installed GPT for Excel and you have trouble signing in with Microsoft.

Solutions
  • Check which versions of Excel and which browsers are supported by this extension in our FAQ.
  • Try using the web version of Excel instead of the desktop version.
  • Try using GPT for Excel in a private/incognito window.

I've entered my OpenAI API key and it's not working

Problem: You have entered an OpenAI API key in the GPT for Excel sidebar and you cannot use it.
Solutions
  • While you have entered your OpenAI API key, you also need to purchase a pack in GPT for Excel to use GPT functions within a Microsoft Excel workbook. Learn more.
  • If you have purchased a pack in GPT for Excel and it's still not working, then you can check if your OpenAI API key is valid by trying the solutions in Your API key is too limited

Need more help?

If none of the listed solutions addresses your issue, fill this form to reach out to our support team for further assistance.