Troubleshooting GPT for Excel

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.

Problems

I bought a pack but my balance is empty

Problem: You have purchased a pack but your balance in GPT for Excel is still empty.

Solution

Click on your balance in GPT for Excel and check that you are using the Microsoft account with which you have purchased your pack.

My packs have disappeared

Problem: You have purchased packs and used GPT for Excel but now all your packs have disappeared from the usage tracking screen.

Solution

Click on your balance in GPT for Excel and check that you are using the Microsoft account with which you have purchased your packs.

I have a ChatGPT Plus subscription, but my balance is empty

Problem: You have a ChatGPT Plus subscription, but GPT for Excel still says that your balance is empty.

Solution

OpenAI's ChatGPT Plus subscription is neither necessary nor sufficient for using the GPT for Work extensions.

Buy a pack to add money to your balance in GPT for Excel.

Sidebar is blank, or fails to load

Error loading Add-Ins

Problem: GPT for Excel sidebar fails to load, or remains blank.

Solutions

• In the desktop version of Excel, open the menu to the right of the sidebar (Windows) or click the info icon (macOS), then choose Reload.
  
  
• 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

• Estimate your costs with the Token counter before executing GPT functions on a large number of cells. Select Token counter from the add-in menu to access it.

  
• Select a cheaper model after comparing their costs with the Cost estimator.
  
• Set up your own API key to save on total cost.

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 uninstall GPT for Excel

Problem: GPT for Excel prompts you to be activated every time you open Excel, which may be caused by remaining GPT formulas in your workbook.

Solution

To find and remove all GPT formulas in your workbook (the experience might be slightly different on Web version and Mac desktop version):

1. Press CTRL + F to open the Find and Replace window.
2. Click Options.
3. In Find what, enter =GPT.
4. Set Within to Workbook, and Look in to Formulas.
5. Click Find All.

You can now locate all GPT formulas and delete them.

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

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.

You need these minimum versions of Microsoft Excel to install the GPT for Excel add-in. Versions vary according to your version of Office:

• Windows - Microsoft 365 subscription and retail perpetual: version 2002, build 12527.20092+
• Windows - Volume-licensed perpetual: version 2108, build 12527.20092+
• Mac: version 16.35, build 20030802+
• Excel on the web

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 in the format org-xxxxxxxxxxx, and click 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 an 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:

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

Text values limited to 255 characters

Text values in formulas are limited to 255 characters.

Problem: The text value in your formula is too long and exceeds Excel's 255-character limit.

Solution

Insert the text into another cell and reference it in your formula, for example, =GPT(A1), where A1 contains the text value.

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

• Temporary: Choose a different model, or wait a few minutes before you try again.
• Permanent: Upgrade your OpenAI account to a higher tier, or use models that don't require an API key.

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

• Temporary: Choose a different model, or wait a few minutes before you try again.
• Permanent: Upgrade your OpenAI account to a higher tier, or use models that don't require an API key.

Need more help?

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