Skip to main content

GPT in Excel errors

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

Invalid prompt parameter​

Error: Invalid prompt parameter.

Problem: Your prompt is not recognized 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 you are using the correct number format for temperature for your locale: 0.8 or 0,8?

  • Check that your arguments are in the correct order. See the function list

Invalid Name​

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

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

Solutions
  • Click GPT in Excel 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 in Excel in the My Add-ins tab.
    4. Click Add.
    5. Refresh the GPT formulas on error.

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 are using the right parameter separator for your locale: , or ;?
  • Check that your arguments are in the correct order. See the function list

Error loading Add-Ins

Problem: GPT in Excel sidebar fails to load, or remain blank.

Solution

Restart Excel, create a new workbook and launch the add-in again.

No credits left​

#Error: No credits left

Problem: You have reached your credit limit or your credit pack has expired after 90 days.

Solution

Click Buy credits to access the Pricing menu and buy more credits.

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.

On this page