Our support hours are from Monday to Friday:
7:30 PM - 12:00 PM (New York)
1:30 AM - 6:00 PM (Paris)
5:00 AM - 9:30 PM (India)
8:30 AM - 1:00 AM (Tokyo)
Check your "Spam" folder in case our responses go to
Spam. You can create a new filter (Filters and Blocked Addresses) in your
Gmail settings for our domain
gptforwork.zendesk.com
and select "Never send it to Spam".
For more information, refer to
this user-friendly tutorial.
Submit a request
Frequently Asked Questions
Billing issues
- 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 add-ons.
Buy a pack to add money to your balance in GPT for Excel. - I bought a pack but my balance is empty
- Problem: You have bought 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. Switch to another account if needed. - My packs have disappeared from the tracking screen
Problem: You have bought 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 bought your packs. Switch to another account if needed.- 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 an API key to save on total cost.
Installation issues
- 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 signed in with the wrong Microsoft account
- Problem: You signed in with the wrong Microsoft account while installing GPT for Excel and need to switch to the correct one.
Solution:
Open the sidebar menu and click Log out to sign out, then sign in again with the correct account. - 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 our uninstallation guide.
- 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):
- Press CTRL + F to open the Find and Replace window.
- Click Options.
- In Find what, enter
=GPT
. - Set Within to Workbook, and Look in to Formulas.
- Click Find All.
You can now locate all GPT formulas and delete them.
Problem: You want to uninstall the add-in, but the Remove option is not available in the add-in Options menu in the Office Add-ins popup.
Solution:
Clear the Microsoft Office cache:
Close all Office applications.
Open Excel and try removing the add-in again.
- 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 compatible with the GPT for Excel add-in on different Microsoft Office platforms.
Windows Mac Online Microsoft 365 subscription:
Version 2002 (Build 12527.20092)
Retail perpetual:
Version 2002 (Build 12527.20092)
Volume-licensed perpetual:
Excel 2021: Version 2108 (Build 12527.20092)
Version 16.35 (Build 20030802)
Supported on:
Google Chrome (latest version)
Microsoft Edge (latest version)
GPT function issues
- 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):
Click Add-ins in the Home tab.
Click More Add-ins.
Select GPT for Excel Word in the My Add-ins tab.
Click Add.
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 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 formats for temperature for your locale: `0.8` or `0,8`?
- Missing parameter
#ERROR: Missing required arguments categories for function GPT_XXX.
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.- 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)
, whereA1
contains the text value.- Functions are stuck on #BUSY
Problem: GPT functions fail to execute and remain in a #BUSY! state, even after reopening your file or restarting Excel.
Solutions:
Open the GPT for Excel sidebar before using any GPT functions:
Click GPT for Excel Word in the Home tab.
Wait for the sidebar to fully load before entering your first GPT formula.
Delete the GPT formula and undo the deletion to run the formula again.
Enter a new GPT formula in a different cell. Subsequent functions typically work correctly.
Use bulk AI tools to avoid this issue in the future, if your use case allows it.
- GPT_WEB function is not working
If you're using the GPT_WEB function and experiencing issues, this is likely because:
The GPT_WEB function only works with the Perplexity Sonar model.
If you've selected a non-Perplexity model that uses an API key, GPT_WEB fails because it tries to use that API key with Perplexity Sonar.
Solutions:
(Recommended)
Select a web-capable model (🌐) from the model switcher and then use the GPT function. Learn more.You can also use a web-capable model as a parameter in the GPT function. Learn more.
If you want to keep using the GPT_WEB function, make sure you first select the Sonar model from the model switcher.
Bulk tool issues
- The Custom prompt tool is not working
Problem: The Custom prompt bulk tool does not give the desired result, often because the prompt is incomplete or the variables are incorrectly formatted.
Solution:
Review the Custom prompt article for guidance on creating effective prompts and using the tool. If the issue persists, contact support.
API key issues
- Your API key is invalid or revoked
Problem: You are trying to set an API key but GPT for Excel won't save it.
Solutions:
Make sure that you copied it correctly, or create a new one and try again.
Solution for immediate use: If immediate use is needed and using your API key is not a priority, select a model without an API key.
- I've entered my API key but it's not working
Problem: You have entered an API key in the GPT for Excel sidebar but you cannot use it.
Solution:
Even though you have entered an API key, you also need to purchase a pack in GPT for Excel. Learn more.
- I can't enter my API key
Problem: You can't enter an API key in the GPT for Excel sidebar because you don't have permission to do so.
Solutions:
Request your space administrator to allow members to use their own API keys. Check the GPT for Work dashboard to see who the administrator or owner of your team is.
Rate limit issues
- Token limit reached
Problem: You are facing a rate limit error message from your AI provider that indicates you've reached your tokens per minute limit.
Solutions:
Temporary: Choose a different model, or wait until your token limit resets.
Permanent: Use models that don't require an API key or use your own OpenAI API key if you belong to a Tier 5 organization.
- Request limit reached
Problem: You are facing a rate limit error message from your AI provider that indicates you've reached your requests per minute limit.
Solutions:
- Temporary: Choose a different model, or wait until your request limit resets: one minute or 24 hours.
Permanent: Use models that don't require an API key or use your own OpenAI API key if you belong to a Tier 5 organization.
Add-in not working
- 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.
- 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.
More questions
- How do I install the GPT for Excel add-in?
Install from Microsoft AppSource:
Go to the installation page.
Click Open in Excel.
Follow the steps until the end.
- Which versions of Excel are compatible with this add-in?
The following table lists the minimum versions of Microsoft Excel compatible with the GPT for Excel add-in on different Microsoft Office platforms.
Windows Mac Online Microsoft 365 subscription:
Version 2002 (Build 12527.20092)
Retail perpetual:
Version 2002 (Build 12527.20092)
Volume-licensed perpetual:
Excel 2021: Version 2108 (Build 12527.20092)
Version 16.35 (Build 20030802)
Supported on:
Google Chrome (latest version)
Microsoft Edge (latest version)
- Which version of Excel am I using?
To check your desktop Excel version, see What version of Office am I using? at Microsoft Support.
If you're using Excel Online, your version is always the latest.
- Which browsers are compatible with GPT for Excel?
GPT for Excel is compatible with the following browsers:
Google Chrome (recommended for the best experience)
Microsoft Edge (only for Windows users, recommended for the best experience)
Mozilla Firefox
Safari (only for Mac users)
- What permissions are required by the GPT for Excel add-in?
The add-in requires to Reason View your basic profile Allows the add-in to see your basic profile (name, image, user name). Maintain access to data you have given it access to Allows the add-in to access the data (your info and documents), even when you are not currently using it. This does not give the app any additional permissions. - What is the pricing of GPT for Excel?
Our pricing options include a consumption-based plan, which is proportional to your usage, and a subscription-based plan, which has a fixed monthly fee.
- How can I add users?
You can add users from the dashboard.
- How is my data processed? Is it used to train models?
We do not read or store any data from your document that you do not use as an input.
If you use a model with an API key, we do not log or store any of the inputs submitted or outputs received.
Whether you use a model with or without an API key, Talarian does not use your inputs and outputs to train language models.
For more information, see the Security and privacy FAQ.
- Do I need my own API key?
Yes, if you are on a subscription plan.
No, if you use prepaid packs, many models are available without any API key.
- Can I use my own API key?
Yes.
Using API keys offers several benefits:
More models. Access a wider range of models from a bigger pool of AI providers than what is available without API keys.
More control. Monitor and manage your AI usage and costs directly on the AI provider's platform.
Improved privacy. We do not log inputs and outputs when you use a model with an API key. For more information, see our security and privacy FAQ.
Reduced costs. If you're on usage-based pricing, using an API key reduces costs. You pay the model usage fees directly to the AI provider, while paying a reduced service fee for GPT for Work.
infoUsing API keys is mandatory if you're on a subscription plan.
infoIf you're a member of a space that does not allow personal API keys, you cannot use your own keys, but you will still benefit from any space API keys set by the space owner.
- Is gpt-4o supported?
Yes, gpt-4o and gpt-4o-mini are supported with and without an API key.
- Is GPT for Excel connected to the web?
Yes, all bulk AI tools and functions in GPT for Excel can access up-to-date information using models with web search capabilities (indicated by the 🌐 icon in the model switcher).
- Is web browsing available with gpt-4 and gpt-4o?
No, but you can use models with web search capabilities (indicated by the 🌐 icon in the model switcher).
- Where can I find the list of available GPT functions?
The list along with full documentation and video tutorials is available here. You can also download our Microsoft Excel example template to try out examples.
- Do formulas reload each time the file is opened?
If you have enabled GPT for Excel cache in your workbook, GPT formulas do not reload. Instead, the results are retrieved from the cache, preventing any extra cost or loss of results.
When the cache is not enabled, GPT formulas follow Excel calculation rules and typically reload each time you move, insert, or delete rows or columns in your workbook. This causes extra costs and can lead to loss of results.
- Can GPT for Excel process images?
Yes, GPT for Excel can process images using the GPT_VISION function and the Analyze images (Vision) bulk tool.
- Can I use OpenRouter?
Yes, you can use the OpenRouter service in GPT for Work with an API key. With OpenRouter, you can access AI models from multiple providers through a single API key.
For API key setup instructions, check out Connect OpenRouter.
- Can I use my OpenAI Assistants and custom GPTs?
Yes. You can use OpenAI Assistants and custom GPTs in GPT for Excel:
Set your OpenAI API key and your Assistants will become available in the model switcher.
You can replicate your custom GPTs as Assistants to make them available in the model switcher.
- Can I reference data located in another sheet in bulk tools?
Yes, in the prompt field of the Custom prompt bulk tool, you can reference cells located in another sheet within the same spreadsheet. Use the following syntax for the reference:
{{SheetName!Cell}}
or{{SheetName!Range}}
For example, to reference cells A1 to B5 in a sheet named Categories, use:
{{Categories!A1:B5}}
- Can I transfer my balance between GPT for Sheets and GPT for Excel or Word?
Packs are not directly transferable between platforms, but you can request a balance transfer between GPT for Sheets and GPT for Excel or Word. Here's what you need to know:
Packs purchased for Microsoft Excel can be used on Microsoft Word and vice versa.
Packs purchased for Google Sheets are separate and can only be used on Google Sheets.
If you need to transfer your balance between Google Sheets and Microsoft Excel or Word, contact our support team.
- Is there a limit to the number of requests I can send?
AI providers enforce rate limits in order to ensure a smooth and fair access to everyone. Learn more.
- How do I uninstall the GPT for Excel add-in?
The uninstallation process is described here.
- Which models can I use?
Check our list of supported models.
- Can I use local models with GPT for Excel?
Yes. GPT for Excel supports integration with Ollama and any LLM server that provides an OpenAI-compatible API, allowing you to use locally running open-source models:
- Which languages can I use?
Models work in many languages, but deliver the best results in English. All we can say is, try it. It is usually better to prompt in the language you want the response to be in. In any case, avoid mixing languages in a prompt.
- How do I get support?
We recommend checking our troubleshooting and FAQ pages.
If that doesn't help, submit a support request and we'll get back to you.
Our support hours are from Monday to Friday:
7:30 PM - 12:00 PM (New York)
1:30 AM - 6:00 PM (Paris)
5:00 AM - 9:30 PM (India)
8:30 AM - 1:00 AM (Tokyo)
Billing issues
- I have a ChatGPT Plus subscription, but my balance is empty
- Problem: You have a ChatGPT Plus subscription, but GPT for Word still says that your balance is empty.
Solution:
OpenAI's ChatGPT Plus subscription is neither necessary nor sufficient for using the GPT for Work add-ons.
Buy a pack to add money to your balance in GPT for Word. - I bought a pack but my balance is empty
- Problem: You have bought a pack but your balance in GPT for Word is still empty.
Solution:
Click on your balance in GPT for Word and check that you are using the Microsoft account with which you have purchased your pack. Switch to another account if needed. - My packs have disappeared from the tracking screen
Problem: You have bought packs and used GPT for Word but now all your packs have disappeared from the usage tracking screen.
Solution:
Click on your balance in GPT for Word and check that you are using the Microsoft account with which you have bought your packs. Switch to another account if needed.
Output issues
- Response is cut or incomplete
Problem: The response you get from GPT for Word seems truncated.
Solution:
Models have a maximum token limit, which is the maximum total number of tokens that can be used in both the input and the response. This means models may not provide complete responses to long queries or when a large portion of text is selected as input.
To stay within the token limit, you can:
In the sidebar, click Clear chat to delete your chat history.
Break up your work into smaller parts.
Select a model with a higher limit.
- Responses don't make sense
Problem: The responses you get from GPT for Word don't match your requests.
Solution:
- Click on Clear chat to delete your chat history. This deletes previous chat messages that might interfere with your current request.
- Refine your prompt and/or select a different model. See our examples for guidance.
API key issues
- Your API key is invalid or revoked
Problem: You are trying to set an API key but GPT for Word won't save it.
Solutions:
Make sure that you copied it correctly, or create a new one and try again.
Solution for immediate use: If immediate use is needed and using your API key is not a priority, select a model without an API key.
- I've entered my API key and it's not working
Problem: You have entered an API key in the GPT for Word sidebar but you cannot use it.
Solution:
Even though you have entered an API key, you also need to purchase a pack in GPT for Word. Learn more.
- I can't enter my API key
Problem: You can't enter an API key in the GPT for Word sidebar because you don't have permission to do so.
Solutions:
Request your space administrator to allow members to use their own API keys. Check the GPT for Work dashboard to see who the administrator or owner of your team is.
Rate limit issues
- Token limit is reached
Problem: You are facing a rate limit error message from your AI provider that indicates you've reached your tokens per minute limit.
Solutions:
Temporary: Choose a different model, or wait until your token limit resets.
Permanent: Use models that don't require an API key or use your own OpenAI API key if you belong to a Tier 5 organization.
- Request limit is reached
Problem: You are facing a rate limit error message from your AI provider that indicates you've reached your requests per minute limit.
Solutions:
- Temporary: Choose a different model, or wait until your request limit resets: one minute or 24 hours.
Permanent: Use models that don't require an API key or use your own OpenAI API key if you belong to a Tier 5 organization.
Installation issues
- I can't sign in after installing
- Problem: You have installed GPT for Word and you have trouble signing in with Microsoft.
Solutions:
- Check which versions of Word and which browsers are supported by this extension.
- Try using the web version of Word instead of the desktop version.
- Try using GPT for Word in a private/incognito window.
- I signed in with the wrong Microsoft account
- Problem: You signed in with the wrong Microsoft account while installing GPT for Word and need to switch to the correct one.
Solution:
Open the sidebar menu and click Log out to sign out, then sign in again with the correct account. - I want to uninstall
Problem: You are not using the add-in in Word or Excel, and you want to uninstall it.
Solution:
To remove the add-in from Word and Excel, follow our uninstallation guide.
- I can't uninstall GPT for Word
Problem: You want to uninstall the add-in, but the Remove option is not available in the add-in Options menu in the Office Add-ins popup.
Solution:
Clear the Microsoft Office cache:
Close all Office applications.
Open Word and try removing the add-in again.
More questions
- How do I install the GPT for Word add-in?
Install from Microsoft AppSource:
Go to the installation page.
Click Open in Word.
Follow the steps until the end.
- Which versions of Word are compatible with this add-in?
The following table lists the minimum versions of Microsoft Word compatible with the GPT for Word add-in on different Microsoft Office platforms.
Windows Mac Online Microsoft 365 subscription:
Version 2205 (Build 15202.10000)
Retail perpetual:
Version 2205 (Build 15202.10000)
Volume-licensed perpetual:
Word 2024: Version 2205 (Build 15202.10000)
Version 16.61 (Build 22040100)
Supported on:
Google Chrome (latest version)
Microsoft Edge (latest version)
- Which version of Word am I using?
To check your desktop Word version, see What version of Office am I using? at Microsoft Support.
If you're using Word Online, your version is always the latest.
- Which browsers are compatible with GPT for Word?
GPT for Word is compatible with the following browsers:
Google Chrome (recommended for the best experience)
Microsoft Edge (only for Windows users, recommended for the best experience)
Mozilla Firefox
Safari (only for Mac users)
- What permissions are required by the GPT for Word add-in?
The add-in requires to Reason View your basic profile Allows the add-in to see your basic profile (name, image, user name). Maintain access to data you have given it access to Allows the add-in to access the data (your info and documents), even when you are not currently using it. This does not give the app any additional permissions. - I have installed GPT for Word, how do I get started?
Now that GPT for Word is installed, you can launch it from the Microsoft Word Home tab and start chatting with your Word documents. Learn more in our quickstart guide.
- What is the pricing of GPT for Word?
Our pricing options include a consumption-based plan, which is proportional to your usage, and a subscription-based plan, which has a fixed monthly fee.
- How can I add users?
You can add users from the dashboard.
- How is my data processed? Is it used to train models?
We do not read or store any data from your document that you do not use as an input.
If you use a model with an API key, we do not log or store any of the inputs submitted or outputs received.
Whether you use a model with or without an API key, Talarian does not use your inputs and outputs to train language models.
For more information, see the Security and privacy FAQ.
- Do I need my own API key?
Yes, if you are on a subscription plan.
No, if you use prepaid packs, many models are available without any API key.
- Can I use my own API key?
Yes.
Using API keys offers several benefits:
More models. Access a wider range of models from a bigger pool of AI providers than what is available without API keys.
More control. Monitor and manage your AI usage and costs directly on the AI provider's platform.
Improved privacy. We do not log inputs and outputs when you use a model with an API key. For more information, see our security and privacy FAQ.
Reduced costs. If you're on usage-based pricing, using an API key reduces costs. You pay the model usage fees directly to the AI provider, while paying a reduced service fee for GPT for Work.
infoUsing API keys is mandatory if you're on a subscription plan.
infoIf you're a member of a space that does not allow personal API keys, you cannot use your own keys, but you will still benefit from any space API keys set by the space owner.
- Is gpt-4o supported?
Yes, gpt-4o and gpt-4o-mini are supported with and without an API key.
- Is GPT for Word connected to the web?
Yes, GPT for Word can access up-to-date information using models with web search capabilities (indicated by the 🌐 icon in the model switcher).
- How can I ask questions about my document?
Select some text or the whole document to include the selection as context for your prompt in the chat.
- Why is my response cut or incomplete?
Models have a maximum token limit, which is the maximum total number of tokens that can be used in both the input and the response. This means models may not provide complete responses to long queries or when a large portion of text is selected as input.
To stay within the token limit, you can:
In the sidebar, click Clear chat to delete your chat history.
Break up your work into smaller parts.
Select a model with a higher limit.
- Can I use my OpenAI Assistants and custom GPTs?
No. GPT for Word does not currently support OpenAI Assistants or custom GPTs.
tipYou can use OpenAI Assistants and custom GPTs in GPT for Excel and GPT for Sheets:
Set your OpenAI API key and your Assistants will become available in the model switcher.
You can replicate your custom GPTs as Assistants to make them available in the model switcher.
- Can I use OpenRouter?
Yes, you can use the OpenRouter service in GPT for Work with an API key. With OpenRouter, you can access AI models from multiple providers through a single API key.
For API key setup instructions, check out Connect OpenRouter.
- Can I transfer my balance between GPT for Sheets and GPT for Excel or Word?
Packs are not directly transferable between platforms, but you can request a balance transfer between GPT for Sheets and GPT for Excel or Word. Here's what you need to know:
Packs purchased for Microsoft Excel can be used on Microsoft Word and vice versa.
Packs purchased for Google Sheets are separate and can only be used on Google Sheets.
If you need to transfer your balance between Google Sheets and Microsoft Excel or Word, contact our support team.
- Is there a limit to the number of requests I can send?
AI providers enforce rate limits in order to ensure a smooth and fair access to everyone. Learn more.
- How do I uninstall the GPT for Word add-in?
The uninstallation process is described here.
- Which models can I use?
Check our list of supported models.
- Can I use local models with GPT for Word?
Yes. GPT for Word supports integration with Ollama and any LLM server that provides an OpenAI-compatible API, allowing you to use locally running open-source models:
- Which languages can I use?
Models work in many languages, but deliver the best results in English. All we can say is, try it. It is usually better to prompt in the language you want the response to be in. In any case, avoid mixing languages in a prompt.
- How do I get support?
We recommend checking our troubleshooting and FAQ pages.
If that doesn't help, submit a support request and we'll get back to you.
Our support hours are from Monday to Friday:
7:30 PM - 12:00 PM (New York)
1:30 AM - 6:00 PM (Paris)
5:00 AM - 9:30 PM (India)
8:30 AM - 1:00 AM (Tokyo)
Billing issues
- I have a ChatGPT Plus subscription, but my balance is empty
- Problem: You have a ChatGPT Plus subscription, but GPT for Sheets still says that your balance is empty.
Solution:
OpenAI's ChatGPT Plus subscription is neither necessary nor sufficient for using the GPT for Work add-ons.
Buy a pack to add money to your balance in GPT for Sheets. - I bought a pack but my balance is empty
- Problem: You have bought a pack but your balance in GPT for Sheets is still empty.
Solution:
Click on your balance in GPT for Sheets and check that you are using the Google account with which you have purchased your pack. Switch to another account if needed. - My packs have disappeared from the tracking screen
Problem: You have bought packs and used GPT for Sheets but now all your packs have disappeared from the usage tracking screen.
Solution:
Click on your balance in GPT for Sheets and check that you are using the Google account with which you have bought your packs. Switch to another account if needed.- I get charged when I'm not using GPT for Sheets
Problem: Google Sheets automatically reloads all formulas every few hours. This includes GPT formulas and can lead to unexpected costs.
Solutions:
GPT for Sheets offers a variety of options to control recalculations:
To save results permanently and prevent formula reloading, replace GPT formulas with their results in selected cells or across an entire sheet.
To store results, enable the cache.
To prevent new executions in your spreadsheet, disable GPT formulas.
GPT function issues
- Functions are stuck on "Loading"
Problem: GPT functions fail to execute and remain in a loading state.
Functions sometimes get stuck on loading for unknown reasons, it is a bug in Google Sheets/Google Apps Script, as per the official issue tracker. In most cases, functions start working again within 24 hours.
Solutions:
Try the following solutions:
In the original spreadsheet:
In a new spreadsheet:
Create a new blank spreadsheet.
In the menu bar, select Extensions > GPT for Sheets and Docs > Enable GPT functions.
To test that GPT functions work, enter
=GPT("hello")
in any cell and check that the formula generates a proper "hello" response.If the GPT function worked as expected, delete the formula and copy the contents of the original spreadsheet into the new spreadsheet.
Disable GPT functions in the original spreadsheet. This prevents unexpected costs when the functions suddenly become unstuck, which usually happens within 24 hours.
- Additional configuration required
Additional configuration required. Open the sidebar: Extensions > GPT for Sheets™ and Docs™ > Open.
GPT functions are not working if the sidebar has not been initially opened. Open the GPT for Sheets sidebar to activate your free trial. Check your permissions in the spreadsheet to ensure you can execute GPT functions.
- Script error
ScriptError: Authorisation is required to perform that action.
Problem: You are likely using multiple Google accounts in the same browsing session.
Solution:
Create a dedicated browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
Open the GPT for Sheets and Docs add-on again.
- 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 text if it's 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 formats for temperature for your locale: `0.8` or `0,8`?
- Check that you have quotation marks around your text if it's not in a cell:
- Error: #NAME? Unknown function
Error: #NAME? Unknown function: 'GPT'
Problem: This error is caused by one of the following:
The GPT for Sheets and Docs add-on is not installed.
GPT functions have not been enabled in the spreadsheet.
Google Sheets has stopped recognizing GPT functions in the spreadsheet.
Solutions:
Try the following solutions in order:
In the menu bar, select Extensions and check for GPT for Sheets and Docs. If the add-on is not listed, install it.
Enable GPT functions:
If you're the creator of the spreadsheet: In the menu bar, select Extensions > GPT for Sheets and Docs > Enable GPT functions.
If you're not the creator of the spreadsheet: Ask the creator to enable GPT functions for you, or make a copy of the spreadsheet for yourself.
Reload the add-on for the spreadsheet:
In the menu bar, select Extensions > Add-ons > Manage add-ons.
In the list of installed apps, find GPT for Sheets and Docs and click its options button.
In the options menu, unselect and select Use in this document.
Try the same solutions as in Functions are stuck on 'Loading'.
- Formula parse error
Formula parse error.
Problem: Your formula contains a structural or syntax error, making it uninterpretable by Google Sheets.
Solutions:
- Check that you have quotation marks around your text if it's 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 formats for temperature for your locale: `0.8` or `0,8`?
- Check that you have quotation marks around your text if it's not in a cell:
- Missing parameter
Error: Please set required parameter text in GPT_XXX() 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.- Formulas are reloaded when I open, reload or edit the spreadsheet
Problem: Google Sheets automatically reloads all formulas every few hours. This includes GPT formulas and can lead to unexpected costs and result changes.
Important note: Sorting, filtering, moving columns or rows will reload ALL formulas and generate unexpected costs. Replace formulas with values before moving things around.
Solutions:
GPT for Sheets offers a variety of options to control recalculations:
To save results permanently and prevent formula reloading, replace GPT formulas with their results in selected cells or across an entire sheet.
To store results, enable the cache.
To prevent new executions in your spreadsheet, disable GPT formulas.
- Response is cut or incomplete
Problem: The response you get seems to be incomplete.
Solution:
You need to increase the cut-off limit.
- My results refreshed and I lost data
Problem: Google Sheets automatically reloads all formulas every few hours. This includes GPT formulas and can lead to unexpected result changes.
Solution:
You can recover your data by using the version history of your Google spreadsheet.
You can also take steps to prevent this situation from recurring.
GPT for Sheets offers a variety of options to control recalculations:
To save results permanently and prevent formula reloading, replace GPT formulas with their results in selected cells or across an entire sheet.
To store results, enable the cache.
To prevent new executions in your spreadsheet, disable GPT formulas.
- GPT_WEB function is not working
If you're using the GPT_WEB function and experiencing issues, this is likely because:
The GPT_WEB function only works with the Perplexity Sonar model.
If you've selected a non-Perplexity model that uses an API key, GPT_WEB fails because it tries to use that API key with Perplexity Sonar.
Solutions:
(Recommended)
Select a web-capable model (🌐) from the model switcher and then use the GPT function. Learn more.You can also use a web-capable model as a parameter in the GPT function. Learn more.
If you want to keep using the GPT_WEB function, make sure you first select the Sonar model from the model switcher.
- Request timed out
Error: Google Apps Script has timed out but your result could be in cache if you have cache enabled. Retry this cell to get your result. If your result is in cache it will be fetched without additional costs.
Problem: Your request exceeded the 30-second limit allowed by Google Sheets functions. This timeout is triggered when the AI provider (such as OpenAI) takes too long to respond.
The response time can vary based on:
The model you are using
The time of usage
The current load on the AI provider's servers
Solutions:
Keep the cache enabled so that you can retry formulas that timed out without additional costs.
Choose a model with a faster response time. You can track average response times on our response time tracker.
Set the cut-off limit to a lower value.
Use GPT for Sheets bulk AI tools which are not subject to timeout.
Use GPT for Excel functions which are not subject to timeout.
- The model you are using is very slow at the moment
The model you are using is very slow at the moment which could result in timeouts. We canceled your executions to save you costs. Please try again with a faster model or at a later time.
Problem: You have reached the limit of 10 timeout errors in the past minute with the same model. This is more likely to happen during peak times when the servers of the model providers (such as OpenAI) are experiencing high demand.
The response time can vary based on the specific model you are using and the time of usage.
Solutions:
Choose a model with a faster response time. You can track average response times on our response time tracker.
Set the cut-off limit to a lower value.
Keep the cache enabled so that you can retry formulas that timed out without additional costs.
Use GPT for Excel to completely avoid timeouts.
Bulk tool issues
- Bulk AI tool stuck on "Running..."
Problem: You click Run, but the bulk tool stays stuck on "Running..." and does not complete the task.
Solution:
Click Stop in the sidebar to cancel the current run and then restart it. If the issue persists, contact support.
- The Custom prompt tool is not working
Problem: The Custom prompt bulk tool does not give the desired result, often because the prompt is incomplete or the variables are incorrectly formatted.
Solution:
Review the Custom prompt article for guidance on creating effective prompts and using the tool. If the issue persists, contact support.
API key issues
- Your API key is invalid or revoked
Problem: You are trying to set an API key but GPT for Sheets won't save it.
Solutions:
Make sure that you copied it correctly, or create a new one and try again.
Solution for immediate use: If immediate use is needed and using your API key is not a priority, select a model without an API key.
- I've entered my API key but it's not working
Problem: You have entered an API key in the GPT for Sheets sidebar but you cannot use it.
Solution:
Even though you have entered an API key, you also need to purchase a pack in GPT for Sheets. Learn more.
- I can't enter my API key
Problem: You can't enter an API key in the GPT for Sheets sidebar because you don't have permission to do so.
Solutions:
Request your space administrator to allow members to use their own API keys. Check the GPT for Work dashboard to see who the administrator or owner of your team is.
Rate limit issues
- Service invoked too many times
Problem: You are facing a rate limit error message from Google that indicates you've exceeded the daily limit for external service calls.
- Quota for gmail.com accounts: 20k / day
- Quota for Google Workspace accounts: 100k / day
Google's rate limits apply to all add-ons and scripts, not just ours. If you use multiple scripts or add-ons, your usage counts towards the same rate limits. It is not possible to increase them as explained here.
Solution:
- Quotas reset every 24 hours, so wait for the end of this period to regain access.
- Use bulk AI tools to bypass this error, as they are not subject to Google's rate limits.
- You can use GPT for Excel instead, as this add-in is not affected by Google's rate limits.
- Token limit is reached
Problem: You are facing a rate limit error message from your AI provider that indicates you've reached your tokens per minute limit.
Solutions:
Temporary: Choose a different model, or wait until your token limit resets.
Permanent: Use models that don't require an API key or use your own OpenAI API key if you belong to a Tier 5 organization.
- Request limit is reached
Problem: You are facing a rate limit error message from your AI provider that indicates you've reached your requests per minute limit.
Solutions:
- Temporary: Choose a different model, or wait until your request limit resets: one minute or 24 hours.
Permanent: Use models that don't require an API key or use your own OpenAI API key if you belong to a Tier 5 organization.
Add-on not working
- Multiple Google accounts error
Problem: You are likely using multiple Google accounts in the same browsing session.
Solution:
Create a dedicated browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
Open the GPT for Sheets and Docs add-on again.
- Sidebar is blank
- Problem: GPT for Sheets sidebar is blank, or fails to load.
Solution:
- Open GPT for Sheets in a private browsing window.
If the sidebar loads successfully, check the following:
- Ensure that you are not using multiple Google accounts in the same browser session. If you are, create a new browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
- Clear the cache and cookies on your browser.
- Disable any extension on your regular browser that may be preventing GPT for Sheets from launching. You can troubleshoot this by disabling one by one the extensions, reloading your Google spreadsheet and trying to launch the sidebar again.
If the problem persists, submit a support request.
- Menu only shows 'Help'
- Problem: When you select Extensions > GPT for Sheets and Docs, the only option you see is Help. Accessing the Extensions menu immediately after opening your spreadsheet may cause this problem.
Solution:
Refresh your page, wait 30 seconds, then try to access the Extensions menu again.
More questions
- How do I install the GPT for Sheets add-on?
Install from the Google Workspace Marketplace:
Go to the installation page.
Click Install.
Follow the steps until the end.
- Which browsers are compatible with GPT for Sheets?
GPT for Sheets is compatible with the following browsers:
Google Chrome (recommended for the best experience)
Microsoft Edge (only for Windows users)
Mozilla Firefox
Safari (only for Mac users)
- What permissions are required by the GPT for Sheets add-on?
The add-on requires to Reason View and manage documents that this application has been installed in We need to be able to inject responses in the Google documents that you launch the add-on in. View and manage spreadsheets that this application has been installed in We need to be able to inject results in the Google spreadsheets in which the GPT functions are enabled. See, edit, and delete all your Google Sheets spreadsheets (with bulk AI tools) We need to interact with the spreadsheets to access and modify the content of the cells when you're using bulk tools. - What is the pricing of GPT for Sheets?
Our pricing options include a consumption-based plan, which is proportional to your usage, and a subscription-based plan, which has a fixed monthly fee.
- How can I add users?
You can add users from the dashboard.
- How is my data processed? Is it used to train models?
We do not read or store any data from your document that you do not use as an input.
If you use a model with an API key, we do not log or store any of the inputs submitted or outputs received.
Whether you use a model with or without an API key, Talarian does not use your inputs and outputs to train language models.
For more information, see the Security and privacy FAQ.
- Do I need my own API key?
Yes, if you are on a subscription plan.
No, if you use prepaid packs, many models are available without any API key.
- Can I use my own API key?
Yes.
Using API keys offers several benefits:
More models. Access a wider range of models from a bigger pool of AI providers than what is available without API keys.
More control. Monitor and manage your AI usage and costs directly on the AI provider's platform.
Improved privacy. We do not log inputs and outputs when you use a model with an API key. For more information, see our security and privacy FAQ.
Reduced costs. If you're on usage-based pricing, using an API key reduces costs. You pay the model usage fees directly to the AI provider, while paying a reduced service fee for GPT for Work.
infoUsing API keys is mandatory if you're on a subscription plan.
infoIf you're a member of a space that does not allow personal API keys, you cannot use your own keys, but you will still benefit from any space API keys set by the space owner.
- Is gpt-4o supported?
Yes, gpt-4o and gpt-4o-mini are supported with and without an API key.
- Is GPT for Sheets connected to the web?
Yes, all bulk AI tools and functions in GPT for Sheets can access up-to-date information using models with web search capabilities (indicated by the 🌐 icon in the model switcher).
scrape web pages- Is web browsing available with gpt-4 and gpt-4o?
No, but you can use models with web search capabilities (indicated by the 🌐 icon in the model switcher). You can also scrape web pages directly from Sheets.
- Where can I find the list of available GPT functions?
The list along with full documentation and video tutorials is available here. You can also copy our Google Sheets example template to try out examples.
- Can GPT for Sheets process images?
Yes, GPT for Sheets can process images using the GPT_VISION function.
- Can I use my OpenAI Assistants and custom GPTs?
Yes. You can use OpenAI Assistants and custom GPTs in GPT for Sheets:
Set your OpenAI API key and your Assistants will become available in the model switcher.
You can replicate your custom GPTs as Assistants to make them available in the model switcher.
- Can I reference data located in another sheet in bulk tools?
Yes, in the prompt field of the Custom prompt bulk tool, you can reference cells located in another sheet within the same spreadsheet. Use the following syntax for the reference:
{{SheetName!Cell}}
or{{SheetName!Range}}
For example, to reference cells A1 to B5 in a sheet named Categories, use:
{{Categories!A1:B5}}
- Can I transfer my balance between GPT for Sheets and GPT for Excel or Word?
Packs are not directly transferable between platforms, but you can request a balance transfer between GPT for Sheets and GPT for Excel or Word. Here's what you need to know:
Packs purchased for Microsoft Excel can be used on Microsoft Word and vice versa.
Packs purchased for Google Sheets are separate and can only be used on Google Sheets.
If you need to transfer your balance between Google Sheets and Microsoft Excel or Word, contact our support team.
- Is there a limit to the number of requests I can send?
AI providers enforce rate limits in order to ensure a smooth and fair access to everyone. Learn more.
- Who can execute GPT functions in a shared Google spreadsheet?
After the Owner/Creator of a Google spreadsheet enables GPT functions, any user with Editor access to the spreadsheet can execute GPT functions. Learn more.
- How do I uninstall the GPT for Sheets add-on?
The uninstallation process is described here.
- Which models can I use?
Check our list of supported models.
- Which languages can I use?
Models work in many languages, but deliver the best results in English. All we can say is, try it. It is usually better to prompt in the language you want the response to be in. In any case, avoid mixing languages in a prompt.
- How do I get support?
We recommend checking our troubleshooting and FAQ pages.
If that doesn't help, submit a support request and we'll get back to you.
Our support hours are from Monday to Friday:
7:30 PM - 12:00 PM (New York)
1:30 AM - 6:00 PM (Paris)
5:00 AM - 9:30 PM (India)
8:30 AM - 1:00 AM (Tokyo)
- Can I use OpenRouter?
Yes, you can use the OpenRouter service in GPT for Work with an API key. With OpenRouter, you can access AI models from multiple providers through a single API key.
For API key setup instructions, check out Connect OpenRouter.
- Can I use DeepSeek?
Yes, DeepSeek models are supported in GPT for Work with an API key. With DeepSeek, you can access powerful AI models at lower costs.
For API key setup instructions, check out Select a model.
Billing issues
- I have a ChatGPT Plus subscription, but my balance is empty
- Problem: You have a ChatGPT Plus subscription, but GPT for Docs still says that your balance is empty.
Solution:
OpenAI's ChatGPT Plus subscription is neither necessary nor sufficient for using the GPT for Work add-ons.
Buy a pack to add money to your balance in GPT for Docs. - I bought a pack but my balance is empty
Problem: You have bought a pack but your balance in GPT for Docs is still empty.
Solution:
Click on Billing in GPT for Docs and check that you are using the Google account with which you have purchased your pack. Switch to another account if needed.
- My balance is not visible
Problem: You can't find a way to track your balance in GPT for Docs.
Solution:
You can track your balance by signing in to the dashboard with the same Google account you use with GPT for Docs.
Output issues
- Response is cut or incomplete
This response was truncated. Choose a model with a larger context window.
Problem: The response you get from GPT for Docs is truncated.
Solution:
Models have a maximum token limit, which is the maximum total number of tokens that can be used in both the input and the response. This means models may not provide complete responses to long queries or when a large portion of text is selected as input.
To stay within the token limit, you can:
Highlight a smaller portion of text in your document.
Reduce the value of Max response tokens.
Select a model with a higher limit.
API key issues
- Your API key is invalid
Problem: You are trying to set an API key but GPT for Docs won't save it.
Solutions:
Make sure that you copied it correctly, or create a new one and try again.
Solution for immediate use: If immediate use is needed and using your API key is not a priority, select a model without an API key.
- I've entered my API key and it's not working
Problem: You have entered an API key in the GPT for Docs sidebar but you cannot use it.
Solution:
Even though you have entered an API key, you also need to purchase a pack in GPT for Docs. Learn more.
- I can't enter my API key
Problem: You can't enter an API key in the GPT for Docs sidebar because you don't have permission to do so.
Solutions:
Request your space administrator to allow members to use their own API keys. Check the GPT for Work dashboard to see who the administrator or owner of your team is.
Rate limit issues
- Token limit is reached
Problem: You are facing a rate limit error message from your AI provider that indicates you've reached your tokens per minute limit.
Solutions:
Temporary: Choose a different model, or wait until your token limit resets.
Permanent: Use models that don't require an API key or use your own OpenAI API key if you belong to a Tier 5 organization.
- Request limit is reached
Problem: You are facing a rate limit error message from your AI provider that indicates you've reached your requests per minute limit.
Solutions:
- Temporary: Choose a different model, or wait until your request limit resets: one minute or 24 hours.
Permanent: Use models that don't require an API key or use your own OpenAI API key if you belong to a Tier 5 organization.
Installation issues
- I want to uninstall
Problem: You are not using the add-on in Docs or Sheets, and you want to uninstall it.
Solution:
To remove the add-on from Docs and Sheets, follow our uninstallation guide.
Add-on not working
- Multiple Google accounts error
Problem: You are likely using multiple Google accounts in the same browsing session.
Solution:
Create a dedicated browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
Open the GPT for Sheets and Docs add-on again.
- Sidebar is blank
- Problem: GPT for Docs sidebar is blank, or fails to load.
Solution:
- Open GPT for Docs in a private browsing window.
If the sidebar loads successfully, check the following:
- Ensure that you are not using multiple Google accounts in the same browser session. If you are, create a new browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
- Clear the cache and cookies on your browser.
- Disable any extension on your regular browser that may be preventing GPT for Docs from launching. You can troubleshoot this by disabling one by one the extensions, reloading your Google document and trying to launch the sidebar again.
If the problem persists, submit a support request.
- Menu only shows 'Help'
- Problem: When you select Extensions > GPT for Sheets and Docs, the only option you see is Help. Accessing the Extensions menu immediately after opening your document may cause this problem.
Solution:
Refresh your page, wait 30 seconds, then try to access the Extensions menu again.
More questions
- How do I install the GPT for Docs add-on?
Install from the Google Workspace Marketplace:
Go to the installation page.
Click Install.
Follow the steps until the end.
- Which browsers are compatible with GPT for Docs?
GPT for Docs is compatible with the following browsers:
Google Chrome (recommended for the best experience)
Microsoft Edge (only for Windows users)
Mozilla Firefox
Safari (only for Mac users)
- What permissions are required by the GPT for Docs add-on?
The add-on requires to Reason View and manage documents that this application has been installed in We need to be able to inject responses in the Google documents that you launch the add-on in. View and manage spreadsheets that this application has been installed in We need to be able to inject results in the Google spreadsheets in which the GPT functions are enabled. See, edit, and delete all your Google Sheets spreadsheets (with bulk AI tools) We need to interact with the spreadsheets to access and modify the content of the cells when you're using bulk tools. - I have installed GPT for Docs, how do I get started?
Now that GPT for Docs is installed, you can launch it from the Google Docs Extensions menu and start editing or generating content with the add-on. Learn more in our quickstart guide.
- What is the pricing of GPT for Docs?
Our pricing options include a consumption-based plan, which is proportional to your usage, and a subscription-based plan, which has a fixed monthly fee.
- How is my data processed? Is it used to train models?
We do not read or store any data from your document that you do not use as an input.
If you use a model with an API key, we do not log or store any of the inputs submitted or outputs received.
Whether you use a model with or without an API key, Talarian does not use your inputs and outputs to train language models.
For more information, see the Security and privacy FAQ.
- Do I need my own API key?
Yes, if you are on a subscription plan.
No, if you use prepaid packs, many models are available without any API key.
- Can I use my own API key?
Yes.
Using API keys offers several benefits:
More models. Access a wider range of models from a bigger pool of AI providers than what is available without API keys.
More control. Monitor and manage your AI usage and costs directly on the AI provider's platform.
Improved privacy. We do not log inputs and outputs when you use a model with an API key. For more information, see our security and privacy FAQ.
Reduced costs. If you're on usage-based pricing, using an API key reduces costs. You pay the model usage fees directly to the AI provider, while paying a reduced service fee for GPT for Work.
infoUsing API keys is mandatory if you're on a subscription plan.
infoIf you're a member of a space that does not allow personal API keys, you cannot use your own keys, but you will still benefit from any space API keys set by the space owner.
- Is gpt-4o supported?
Yes, gpt-4o is supported with and without an API key.
- Why is my response cut or incomplete?
Models have a maximum token limit, which is the maximum total number of tokens that can be used in both the input and the response. This means models may not provide complete responses to long queries or when a large portion of text is selected as input.
To stay within the token limit, you can:
Highlight a smaller portion of text in your document.
Reduce the value of Max response tokens.
Select a model with a higher limit.
- Can I use my OpenAI Assistants and custom GPTs?
No. GPT for Docs does not currently support OpenAI Assistants or custom GPTs.
tipYou can use OpenAI Assistants and custom GPTs in GPT for Excel and GPT for Sheets:
Set your OpenAI API key and your Assistants will become available in the model switcher.
You can replicate your custom GPTs as Assistants to make them available in the model switcher.
- Is there a limit to the number of requests I can send?
AI providers enforce rate limits in order to ensure a smooth and fair access to everyone. Learn more.
- How do I uninstall the GPT for Docs add-on?
The uninstallation process is described here.
- Which models can I use?
Check our list of supported models.
- Which languages can I use?
Models work in many languages, but deliver the best results in English. All we can say is, try it. It is usually better to prompt in the language you want the response to be in. In any case, avoid mixing languages in a prompt.
- How do I get support?
We recommend checking our troubleshooting and FAQ pages.
If that doesn't help, submit a support request and we'll get back to you.
Our support hours are from Monday to Friday:
7:30 PM - 12:00 PM (New York)
1:30 AM - 6:00 PM (Paris)
5:00 AM - 9:30 PM (India)
8:30 AM - 1:00 AM (Tokyo)