GPT in Excel errors

Resolve common errors in Microsoft Excel and find solutions.

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 our reference here

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

Problem: You haven't enabled the GPT functions.

Solution

Click GPT in Excel from the Ribbon's Home tab.

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 our reference here

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

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