ChatGPT for Excel Not Working or Not Showing? How to Fix It

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for ChatGPT for Excel Not Working or Not Showing? How to Fix It.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for ChatGPT for Excel Not Working or Not Showing? How to Fix It.

The ChatGPT add-in for Excel is usually missing or failing for one of five reasons: it was never added from Home > Add-ins, you signed in with the wrong ChatGPT account, an admin blocked the store or has not enabled your workspace, your plan's usage limit is spent, or the request needs an unsupported feature.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

One comparison narrows it down quickly. Open Excel for the web with the same work account, open ChatGPT and ask it to total a six-row test sheet whose answer you already know. If the web version works, the fault sits in desktop Excel or its sign-in; if both fail, look at the account, the admin settings or the plan.

How do you fix the ChatGPT Excel add-in by symptom?

Match the exact wording on screen to a symptom row below, then apply that row's fix; write the wording down before you change anything, and keep the real workbook closed while you test. Every row below comes from OpenAI's or Microsoft's own documentation, checked in November 2026; menu names can move, so match the wording rather than the position.

What you seeLikely causeFixHow you know it worked
No ChatGPT button on the ribbonNever added for your user, or the add-in list has not refreshedHome > Add-ins, search ChatGPT, Add. If it was added before: Home > Add-ins > More add-ins > My Add-ins > Refresh, then restart ExcelA ChatGPT button appears on the ribbon above the workbook
“Office store not available” when you open the storeAn admin has switched off store access for the whole organisationAsk the admin to deploy ChatGPT centrally, or to restore store accessThe button appears after Excel is relaunched (central deployments can take 24 to 72 hours)
Pane opens and you sign in, but access is refused in a company workspaceThe feature is off for the workspace (Enterprise workspaces start with it disabled) or your role lacks itWorkspace admin: Workspace settings > Permissions & roles > ChatGPT for Excel and Google Sheets > Enable ChatGPT for Excel and SheetsThe same test prompt now runs
“ADD-IN ERROR This add-in could not be started” during sign-in on WindowsAn older single sign-on callback address redirecting to OpenAI's current oneA global admin updates the company's identity provider with the current address from the OpenAI Admin Portal (details below)Sign-in completes inside desktop Excel, not only in the browser
The pane is signed in to the wrong account or workspaceA personal login, or a second ChatGPT account, was usedAdd-in settings menu > Log out, then sign in with the account that holds your plan and choose the right workspaceThe access or plan message disappears
A usage or limit messageFree and Go have limited access; Plus and Pro draw on the plan's agentic usage limit; Business and Enterprise use creditsWait for any stated retry time, shrink the request, or ask the admin about creditsA small request runs again
The answer covers only part of a big workbookThe data did not fit in the model's context windowPoint it at one sheet with @, then work in batches with control totalsRow counts and totals match the source
A request about a PivotTable, Power Query, slicer or macro failsThe feature is on OpenAI's unsupported listDo that step yourself and give ChatGPT a plain table of valuesThe plain-table version of the request works
Codex in the ChatGPT desktop app cannot find the open workbookDifferent accounts in Codex and the add-in, or Codex control switched offUse the same account and workspace in both; in the add-in, ••• menu > Allow Codex control; keep the workbook and pane openCodex finds the workbook when asked again

Work down the rows in that order, because the early ones are cheap to check and the later ones depend on the earlier ones being right. Change one thing, repeat the same test prompt, and note the result. If you reinstall, sign out and change a setting all at once, a fix tells you nothing about the cause, and the same fault can return on the next colleague's machine.

A short incident note keeps this honest: what you expected, what appeared, the exact message, whether a new blank workbook behaves the same, whether a colleague with the same plan can reproduce it, and what changed recently (a new laptop, a password reset, a plan change). That note is also what an administrator or OpenAI support will ask for later.

How do you add the real ChatGPT add-in to Excel?

Open Home, then Add-ins, search for ChatGPT, add OpenAI's listing and sign in with the ChatGPT account that holds your plan.

OpenAI's documented steps work in Excel on the desktop or on the web: go to Home, then Add-ins, search for ChatGPT, add it, open ChatGPT from the ribbon and sign in with the ChatGPT account that holds your plan. The listing to use is the one OpenAI links from its ChatGPT for Excel and Google Sheets help article, which also covers the Google Sheets version.

OpenAI's add-in signs in with your ChatGPT account. If the add-in you opened asks for an API key, a separate subscription or a different provider's login, you are almost certainly in another company's product with its own billing and support. Close it, note its name, and install the listing OpenAI links to before testing anything else; a ChatGPT Plus plan does not pay for a different vendor's add-in.

To see what is already installed, Microsoft's route on Windows is Home > Add-ins > More add-ins, then the My Add-ins tab. If an add-in you know you installed is missing from that list, Microsoft's instruction is to select Refresh to reload it. Right-click an entry and choose Add-in details to read more about it. A colleague's ChatGPT button on their screen proves nothing about your own user: each person needs the add-in installed or assigned.

Take a mortgage broker who tried an Excel AI tool during an earlier trial. The pane that opens now asks for credentials from an unfamiliar provider, so the broker removes that entry from My Add-ins (right-click > Remove), adds ChatGPT from Home > Add-ins, and repeats the six-row test in a new workbook. The test passes, which shows the problem was the wrong product, not the account.

Check the account and plan before paying for an upgrade

OpenAI makes the add-in available on Free, Go, Plus, Pro, Business, Enterprise, Edu and K-12 plans. Its help article says Free and Go include limited usage, while Plus and Pro include access subject to the plan's agentic usage limit. The ChatGPT pricing comparison shows the same split for the Excel, Word, PowerPoint and Google Sheets extensions: limited on Free and Go, included on Plus, expanded on Pro.

Business, Enterprise, Edu and K-12 workspaces had a free preview that ran to 2 June 2026; since then, usage follows each plan's credits and usage terms, and workspace admins can monitor usage and buy credits for more access. OpenAI also notes that larger workbooks, multi-step edits and complex analysis use more of the limit, so a 40-tab model eats into it faster than a one-sheet list.

Two sign-ins are involved and they are separate. Excel's own sign-in (File > Account shows the user) says which Microsoft account Office is using; the ChatGPT pane has its own login. A green tick in one says nothing about the other. If the pane is on the wrong account, use Log out in the add-in's settings menu and sign in again, choosing the workspace that holds the plan you mean to use.

Here is how that plays out for a small financial advice firm. One adviser opens the add-in and, after a handful of requests, gets a limit message. The firm pays for a Business workspace, but the pane shows the adviser's personal Free login from a home laptop. Logging out and signing in to the firm's workspace fixes it without buying anything, and without any client holdings leaving the approved account.

Two more limits explain many “it forgot” complaints. OpenAI says spreadsheet chats run separately from your main ChatGPT history, with no syncing between them, and that spreadsheet chats have no access to ChatGPT memory. A request such as “do last month's clean-up again” therefore fails even when everything is installed correctly. Put the rules in the request, keep them on a Rules sheet the request can read, or use a Skill if your workspace has one for the job (the add-in's + button lists them).

Which admin settings block the ChatGPT add-in at work?

Two separate admins can block the add-in at work, the Microsoft 365 admin and the ChatGPT workspace admin. The Microsoft 365 admin decides whether Office add-ins can be installed or must be assigned, and the ChatGPT workspace admin decides whether the workspace can use the spreadsheet feature at all. Fixing one leaves the other untouched.

On the Microsoft side, a setting called Let users access the Office Store sits under Settings > Org settings > Services > User owned apps and services. It is on by default. When an admin clears it, people who try the store see the “Office store not available” message, and add-ins arrive only through central deployment, which Microsoft documents step by step: Settings > Integrated apps > Add-ins > Deploy Add-in, then assign it to everyone, specific users or groups, or just the admin.

Microsoft warns that users may need to relaunch Office to see a deployed add-in and that add-ins can take 24 to 72 hours to appear on the ribbon. So an add-in deployed on Tuesday afternoon and missing on Wednesday morning is not yet a fault. Wait out that window before anyone starts deleting and redeploying.

On the ChatGPT side, OpenAI says the feature is disabled by default in Enterprise workspaces. A workspace admin turns it on under Workspace settings > Permissions & roles > ChatGPT for Excel and Google Sheets > Enable ChatGPT for Excel and Sheets, and that one switch covers both Excel and Google Sheets. Admins also decide which connected apps appear inside the add-in, so a missing app in the pane is often a permission, not a bug.

For example, a B2B software reseller deploys ChatGPT to a five-person reporting group. Three days later four people can use it and the fifth cannot. The admin finds that the fifth person was added to the group after the deployment and was never given the workspace role. Adding the role and relaunching Excel fixes it; nobody needed organisation-wide changes.

When you ask an admin for help, give them a decision they can make, not a complaint. A request that works:

Hi [first name], ChatGPT for Excel opens for me but stops with this message: [exact wording, screenshot attached]. I am signed in to our company ChatGPT workspace as [work email]. Could you check (1) whether the add-in is assigned to me in Integrated apps, if we deploy add-ins centrally, and (2) whether my role has Enable ChatGPT for Excel and Sheets turned on? My test workbook contains no customer data. Thanks, [your name]

What does the “add-in could not be started” error mean?

The “add-in could not be started” error is the one start-up error OpenAI documents by name, and it can appear during the single sign-on callback. The full message is “ADD-IN ERROR This add-in could not be started. Close this dialog to ignore the problem or click Restart to try again.” It can happen when an older callback address redirects to OpenAI's current sign-on endpoint. Signing in through a browser may still work while the Windows Office add-in fails to complete that redirect.

Clicking Restart or reinstalling Excel does not touch that cause. OpenAI's fix is for a global admin of the company's tenant: in the OpenAI Admin Portal, open Identity > SSO > Manage SSO, copy the ACS URL (the address the identity provider sends people back to after login), then update the OpenAI Enterprise Application in the identity provider and make that new URL the default. If your company does not use single sign-on with ChatGPT, this error points elsewhere, so go back to the table.

Which route should a company use to deploy the ChatGPT add-in?

An add-in reaches a person's Excel in three ways, the store, central deployment or sideloading, and the right one depends on how your company manages Office.

RouteWho does itWhen it fitsWatch for
Store install from Home > Add-insEach userStore access is allowed, which is Microsoft's defaultInstalling a similarly named product by mistake
Central deployment from the MarketplaceMicrosoft 365 adminThe company wants control over who gets itThe 24 to 72 hour wait; Microsoft says updates then reach users automatically
Central deployment from OpenAI's manifest fileMicrosoft 365 adminThe organisation cannot reach the store for this add-inUse only the manifest linked from OpenAI's help article

Microsoft's My Add-ins dialog also has an Upload option under Manage My Add-ins for adding an add-in from a file on your own device, which is what people mean by sideloading. OpenAI does not document that as a route for its add-in; its fallback is the admin deployment from its manifest file. If your company has blocked the store, uploading a manifest copied from a forum to get round the block is a policy question for the admin, not a fix.

How do you tell whether your Office version is the problem?

Compare the same account in Excel for the web with desktop Excel to isolate an Office version problem. OpenAI's install steps cover Excel on the desktop and on the web, and when its pages were checked for this tutorial in November 2026 they gave no minimum Excel version. So rather than trusting a minimum build copied from an old forum post, record what you actually run: on Windows, File > Account shows the product name and version under Product Information, and About Excel adds the full build and 32-bit or 64-bit; on a Mac, use the Excel menu > About Excel.

Then run the same six-row test, with the same account and the same prompt, in Excel for the web. If the web version works and the desktop one does not, you have shown the problem is in the desktop environment: an Office update, a sign-in policy, a security control or the single sign-on error above. Hand IT that pair of results instead of a vague “ChatGPT is broken”.

A typical pattern looks like this: the browser accepts the login, but the desktop pane returns to its start screen every time. With the version noted and the web test passing, IT can go straight to pending Office updates and the sign-on setup. Nobody should share passwords to compare machines or switch off company security settings to make the pane open.

Prove the fix with a six-row sheet you can check by hand

Use invented data for the acceptance test, not the production workbook. For the main worked example, a B2B software reseller creates a sheet called TestSales with a unique source ID on each of six rows: four invoices of $400, $650, $300 and $900, a credit of minus $50, and a final $650 row that repeats the second invoice's document and line number. The figures deliberately test a positive amount, a negative amount and a duplicate.

The raw six-row sum is $2,850. If the repeated $650 row is confirmed as an accidental duplicate, the five genuine transactions total $2,200. Those two numbers are your known answers before the add-in says anything.

Inspect TestSales only. Make no edits.
Report the six source-row IDs, the signed total and any rows that
share a document and line number. Keep the minus $50 credit.
Do not remove anything. Expected raw total: $2,850.

A good reply lists six IDs, reports $2,850 and flags the repeated invoice line. A reply of $2,200 has quietly excluded a row before you approved it. A reply of $2,900 has probably dropped the credit ($2,850 plus $50). OpenAI says the add-in links its answers to the cells it references and asks for permission before making changes, so click through those cell references rather than trusting the summary text.

Only then ask for a derived clean sheet: confirm the duplicate against the original export, approve its exclusion, and expect five rows totalling $2,200 with the excluded row's ID listed on an exceptions tab. When both numbers come back right, write the result in the incident note: add-in opens, right account, $2,850 read-only check passed, $2,200 derived table passed. “Fixed” on its own tells the next person nothing.

If you want to get more out of the spreadsheet side, The Complete Excel Course with AI Integration on Coding Liquids covers Excel itself.

Which Excel features does the ChatGPT add-in not support?

The ChatGPT add-in does not yet support Office Scripts, Power Query, Pivot and Data Model features, data validation, slicers, timelines or VBA and macro automation. OpenAI's FAQ lists these advanced Excel features, and the help article adds that VBA and macros may not be fully supported. A request that depends on one of those will fail however many times you reinstall. Give the add-in a plain values table and do the pivot, query refresh or macro yourself; the PivotTable workaround tutorial covers that job.

Size is the other limit. OpenAI says very large workbooks may not fit in the context window, which can lead to partial results, and files you attach in the pane are capped at 20 attachments per message and 25 MB per file. Partial results are harder to spot than an error because the answer still sounds complete.

So ask for coverage evidence every time: which sheets were read, the first and last source IDs, the row count and the signed total. Suppose an export holds 12,000 transactions and the answer discusses 2,000. Split it into three batches of 4,000 rows by invoice-number range, get a count and total for each, and check that the counts add to 12,000 with no ID appearing in two batches. If the totals match but IDs repeat, a missing row may be hiding behind a duplicated one.

The sales spreadsheet checking tutorial covers this upload-and-verify job in more depth, and the formula verification tutorial shows how to work out an expected answer independently instead of asking the same model to confirm its own figure.

Why does the ChatGPT add-in edit the wrong cells?

The ChatGPT add-in edits the wrong cells when a request is unclear, because OpenAI warns that it can change or delete data when an instruction does not say what to keep. Take an operator who writes “Fix this sheet and make it ready”. The labels come back tidy, but an approved manual adjustment has gone, because the request never said what to keep.

OpenAI's own advice is to say what to preserve, what to overwrite and where; to ask for a plan before big edits; to @-mention the sheets you mean; and to duplicate the file first for important work. Applied to the same job, the request becomes:

Before editing, list exactly which tabs and ranges you will change.
Work on the Customers column of Sheet1 only. Propose a name-mapping
table on a new tab. Do not change any amount, formula or the row
marked ADJ-07. Wait for my approval before applying the mapping.

If a request that narrow still changes an unrelated amount, stop using that output and keep the evidence: the cell address, its original value and the new value. One concrete wrong edit, with a redacted before-and-after copy, is far more useful to support than a general complaint about accuracy.

If you want help fitting AI into how your team actually works, I offer one-to-one AI consultations for small businesses.

What should you send OpenAI support?

Check OpenAI's status page for a live incident before writing to support, which is one of OpenAI's own troubleshooting steps. If nothing is listed, send the details OpenAI's help centre asks for in support requests: your account email, a screenshot of the issue, the timestamp and time zone, the platform or browser you used, and the request ID if one is shown. Add the Excel version, desktop or web, and the result of your six-row test.

Keep customer data, credentials and private financial details out of screenshots, and never post a production workbook in a public forum to demonstrate a fault. A redacted test file that reproduces the problem says more than a real one.

When the add-in is working again, reopen a copy of the real workbook and give it one bounded task, such as the read-only total, before returning it to the normal reporting cycle. If that passes, keep the test sheet and its known answers, so the next Office update or plan change can be rechecked against them. If it fails, you already know installation and sign-in are fine, so the next look goes to the workbook, the feature used or its size. Once the add-in is steady, the monthly sales export clean-up tutorial gives it a complete, checkable job.

Further reads

Sources: OpenAI's ChatGPT for Excel and Google Sheets page and help article; ChatGPT pricing page; Microsoft Support pages on managing add-ins and finding your Office version; Microsoft Learn pages on Marketplace access and deploying add-ins. Checked 18 November 2026.

Want a second pair of eyes on your setup?

Bring the process you're trying to fix. On a 1:1 call we'll work out which AI tools should handle it, which parts stay manual, and how to roll it out without disrupting the team.

Book a 1:1 call with me