Why Copilot in Excel Is Missing for Half Your Firm — and Dark on Most Client Files

Guide · Updated September 2026 · ~10 min read

Your firm bought Microsoft 365 Copilot. Three weeks later the manager who asked for it is using it, two seniors cannot find the button at all, and the one person who did find it says it will not touch a single client file. Nobody has done anything wrong. Copilot in Excel sits behind about nine separate gates, and an accounting practice trips more of them than almost any other kind of business.

Several of those gates are things firms do on purpose. You sit on a slow update channel so Excel does not change under you in the middle of busy season. Your document system checks files out for editing. Your models run on Manual calculation. Each of those three is documented by Microsoft as a reason Copilot will not appear, or will appear and refuse to edit — and not one of them is in the restart-Excel advice you will find everywhere else. A fourth, the sensitivity label your firm puts on client data, is the one everybody asks about and the one you will have to test on your own tenant; there is an honest section on it below.

Work through this in order and every person in the firm ends up with one of three answers: the licence does not cover them, the device does not, or the file does not. The buying question — whether the add-on is worth putting on everybody — is at the end, where it belongs.

First, 30 seconds: the button moved to the corner of the grid

Rule this out before you organise anything, because it costs half a minute and it explains a good share of the seniors who "cannot find it". Copilot is in the lower-right corner of the grid, floating over the sheet — not a ribbon tab, and no longer a fixed button on the Home tab. Microsoft's Get started with Copilot in Excel page is blunt about it: "Select the Copilot icon in the lower-right corner of Excel."

That is the Copilot Dynamic Action Button. Per Microsoft's documentation for the button, it is now "a single, consistent entry point" in "a consistent corner location in Word, Excel, and PowerPoint, on Windows, Mac, and the web". It rolled out worldwide between April and June 2026, with GCC, GCC High and DoD environments following from October 2026, so anything written before that points at the Home tab in good faith. Right-click it and choose Move to ribbon to put it back where the screenshots say it should be: on Windows and macOS that preference persists per app, on the web only for the current session. Once open, the pane offers three modes — allow editing, plan and chat only.

Microsoft is equally blunt about who sees the button at all: "The Copilot Dynamic Action Button only appears for users who have access to Copilot (through a Microsoft 365 Personal, Family, or Premium subscription; or a Microsoft Copilot license)." No button anywhere is a licensing signal first and a bug second, which is why the rest of this page is arranged by licence, device and file rather than by symptom. And if the pane opens and then refuses to edit, stop treating it as the same problem — that is a file-state fault with its own section further down.

Which of your people actually have it: the licence tier that catches firms

This is the step practices skip, and it accounts for most of the missing buttons in a firm-wide rollout. The trap is specific: a practice on Business Premium with Copilot Chat eligibility has been using Copilot on the web for months, reasonably believes "we have Copilot", and buys a handful of add-on licences for the people who asked loudest. Everyone else keeps the tier that explicitly excludes the Excel pane, and nobody finds out until a senior spends an afternoon on a restart-and-reinstall loop.

Microsoft's Copilot in Excel FAQ lists four eligible routes: a Microsoft 365 Personal or Family subscription with an AI credits plan; a Microsoft 365 Premium subscription; a commercial Microsoft Copilot subscription; or a Copilot Chat-eligible Microsoft 365 or Office 365 business or enterprise subscription.

The subtlety that catches business users is that "Copilot Chat-eligible" and "has Copilot in Excel" are not the same thing. Microsoft's admin documentation splits it into three tiers, and the lowest one explicitly excludes the Office apps.

Two footnotes that are easy to miss, and both bite practices. Microsoft states plainly that "Copilot isn't available when using device-based licensing for Microsoft 365 Apps for enterprise", which quietly rules out shared lab and kiosk deployments — and, in a practice, the hot-desk machines in the bookkeeping room and the spare workstation people use when they are in the office two days a week. A senior who sees Copilot on their own laptop and not on the hot-desk has not lost their licence; the device is the gate. Second, the licence has to be on the human, not on an object: the next-but-one section is about the guest accounts, shared mailboxes and service accounts that swallow a Copilot licence without anyone noticing.

The nine gates, in the order a firm hits them

The order matters more than the steps. Two of these settle whole teams at once and cost a minute each; the rest are per-person fiddling that is a waste of a Saturday if the licence was never there. Do them in this order, on one person first, before you roll anything out to the practice.

1. Read the label on the Copilot experience you actually have. Microsoft now displays in-product labels in Word, Excel, PowerPoint and OneNote "to help users identify their Copilot experience". If yours says Copilot Chat, you have the tier that does not include the Excel pane, and no amount of troubleshooting will produce one. Do this before anything else: it answers the whole-team question in one look, and it is the row the licence table above leaves open.
2. Look in the bottom-right corner of the sheet, not the ribbon. Open a normal .xlsx workbook — not a blank window, not Protected View — and check the corner of the grid. If you find it, right-click and choose Move to ribbon so it stops hiding.
3. Check which account Excel is signed into. File > Account, top-left. If your Copilot licence is on you@firm.com and Excel is signed in as you@outlook.com, there is nothing to find. Sign out, sign back in with the licensed account, and restart Excel.
4. Check your update channel. File > Account, under Product Information. If it reads Semi-Annual Enterprise Channel, that is your answer, and it is almost certainly a firm-wide answer rather than a personal one — see the next section.
5. Refresh the licence. A newly assigned Copilot licence often does not reach the desktop app until you force it. File > Account > Update License, then close and restart every Office app — Outlook included, since it holds the session open. On a Mac: the Excel menu > About Excel > More Info > Refresh License.
6. Update Excel. File > Account > Update Options > Update Now. Microsoft's own troubleshooting article opens with "make sure you are running the latest build" rather than naming a minimum version, so update rather than hunting for a build number.
7. Turn the privacy settings back on. File > Account > Account Privacy > Manage Settings. Both "Experiences that analyze your content" and "All connected experiences" must be on. These get switched off by well-meaning IT hardening policies far more often than people expect, and Copilot vanishes without explanation when they are. In a practice this is the gate that produces the strangest pattern of all: the staff whose machines were built by the outsourced IT provider have it off, and the ones who joined before that contract have it on.
8. Ask whether an admin has switched it off. Tenant admins can remove access entirely through the Copilot controls in the Microsoft 365 admin centre, and there is a dedicated AI Administrator role for exactly this. Copilot also needs WebSocket connectivity to *.cloud.microsoft and copilot.cloud.microsoft — blocked by a proxy, TLS inspection or a firewall rule, entry points fail to appear — and the Office Feature Updates task has to be running. All three are IT questions, not user ones.
9. On Excel for the web, allow third-party cookies. Microsoft is specific: "For Copilot to work in Word Online, Excel Online, and PowerPoint Online, you must enable third-party cookies." Blocked cookies break licence validation and the button never renders. Refresh the page afterwards.

If you are the practice manager fielding this rather than the person with the missing button, do not chase it one ticket at a time. Fill in a row per staff member and the pattern names itself: five people with the same label and channel is a licensing decision, one person out of forty is a device. The first four columns come from File > Account on their machine and take under two minutes each.

The update channel finance firms choose on purpose — and what 2606 did to it

This one deserves its own section because it explains the most maddening version of the problem: your colleague has Copilot, you have the same licence, and your Excel does not show it.

Microsoft's support guidance has been consistent: "When using Semi-Annual Enterprise Channel of Microsoft 365, Microsoft Copilot features are not available in your apps. In order to use the features enabled by your assigned Copilot license, you'll need to switch to Current Channel or the Monthly Enterprise Channel." Many finance and professional-services firms sit on Semi-Annual precisely because they do not want Excel changing under a close deadline — a defensible choice that also costs you Copilot.

It is worth being fair to whoever made that choice, because the reasoning is good and it is rarely written down. A practice runs the same workbooks every month for years. A ribbon that moves in the middle of January means forty people relearning a route on the week self-assessment is due. A change to how a function behaves, or to what a paste does, lands in a file a client signs. Pinning the channel is not IT being obstructive; it is the same instinct that makes you keep last year's working paper template. The cost of it used to be invisible, because nothing you were paying for depended on the channel. Copilot is the first thing that does.

What changed: beginning with the Version 2606 update release in July 2026, Microsoft unified Semi-Annual Enterprise Channel into Monthly Enterprise Channel. Per Microsoft's channel unification article, "Devices with users that meet Microsoft Copilot requirements will become eligible for Copilot after the update because they are on the Monthly Enterprise Channel experience." After 2606 installs, File > Account shows Monthly Enterprise Channel even though management tooling may still report Semi-Annual; builds numbered above 20131.20000 have taken the update.

So the practical question for IT is no longer "will you switch channels for me" but "have we taken the 2606 update yet". Organisations that pinned themselves to Version 2508 to delay it were supported only through 8 September 2026, so most will have moved. Check the article above for where this stands now rather than trusting this paragraph in six months.

Ask it in those words, and ask for the answer per device group rather than for the firm. The realistic outcome in a practice that pinned itself is a split estate: the machines rebuilt since the summer are on the Monthly Enterprise experience and see Copilot, the ones nobody has touched are still sitting on a pinned build and do not. That is exactly the pattern the table above is designed to surface, and it is why the channel column is worth filling in even for people whose button is working. If the answer comes back that the firm is still deliberately holding a build, that is a legitimate decision — but it is now a decision to not use something you are being billed for, and the partner who signed the Copilot order should be the one making it rather than hearing about it in March.

The licence landed on the wrong object: guest tenants, shared mailboxes, service accounts

Worth expanding on step 3, because the failure is rarely as obvious as the wrong email address on screen, and because a practice generates more ways to get this wrong in a week than an ordinary business does in a year. Copilot for work requires a Microsoft Entra account, so a personal Microsoft account on a work machine gets you consumer Copilot on the web and nothing in the Excel grid.

Then there is the shape of the problem that is specific to accountants: a lot of the objects your firm signs in as are not people. A licence sitting on any of the following is a licence nobody can use.

• A guest account in a client tenant. You are invited into the client's Microsoft 365 so you can reach their files. That guest object is not the account your own Copilot licence is attached to, and a licence granted on either side does not follow you across. If half your day is spent in client tenants, this is the one to check first.
• A shared mailbox. Practices run accounts@, payroll@ and info@ as shared objects that several people open. Assigning a licence there feels efficient and reaches nobody, because nobody signs Excel in as the mailbox.
• A service account. The account your practice management or document system authenticates as is a common place for a spare licence to be parked, and it never gets in front of a human.
• A leaver's account you kept open. Reassigning the person is not the same as reassigning the licence, and the licence count in the admin centre will look correct either way.

Ask whoever assigned the licences to read back the list of accounts they landed on and compare it against the accounts your staff actually sign Excel in with. Where they match and Copilot is still missing, run File > Account > Update License and restart every Office app, Outlook included.

The last case has no admin-centre trace at all, and in practice it happens daily: Excel is signed into the right account while the file is open from the wrong OneDrive or the wrong SharePoint site. You open a workbook from a link the client sent, work on it for an hour, and the corner of the grid is empty — not because of anything on your machine, but because of where that file lives. Close it, confirm the account under File > Account, and reopen the file from your own tenant's storage. If the workbook has to stay in the client's tenant, treat Copilot as unavailable on it and plan the job accordingly rather than spending twenty minutes proving it to yourself again.

It opens, and it refuses to touch the client file

This is the section that matters most to a firm, because it is the one where everything is licensed correctly, the button is right there, and the answer is still no. The gates below are all file-state gates. Some you can clear in ten seconds; some are your own firm's policy, and the honest answer is that you will not be changing them for a chat pane.

Microsoft's FAQ names each of these:

• Calculation mode. "Copilot editing is only supported when Calculation Options are set to Automatic." This is the one that catches models built by humans. A forty-tab consolidation, a fixed-asset register with a thousand rows of formulas, a group reporting pack: somebody set those to Manual years ago because recalculating on every keystroke made them unusable, and nobody has switched them back since. Copilot's edit mode is simply dead in that workbook until you do. You can switch to Automatic for the duration and back afterwards — just know what you are asking a heavy model to do when you flip it.
• File format. Legacy formats and Strict Open XML Spreadsheet are unsupported. File > Save As and choose Excel Workbook (.xlsx). The practice version of this is the client whose bookkeeping package still exports .xls, or the schedule that has been carried forward from an engagement file since 2012. Re-saving is a genuine per-file fix, but re-saving a client's source export is a decision about your own file trail: keep the original alongside it.
• SharePoint check-out. A file checked out produces an "Unsupported file state" error. Check it back in, close and reopen. This is the one that is not a mistake: a document management system that enforces check-out is doing the job you bought it for, and version control on a client file is worth more than a chat pane. See the platform section below for the one route that still works.
• Sensitivity labels — test this yourself before you assume either way. Every firm with a classification policy labels client data Confidential or the equivalent, so this is the first question anyone asks. Be careful with the answer. The documented label restriction Microsoft published in this area applied to the =COPILOT worksheet function, which "cannot calculate in workbooks labelled Confidential or Highly Confidential" — and that function has since been retired. Whether the Copilot pane behaves the same way on a given label depends on how the label is configured in your own tenant, including whether it applies encryption and what usage rights it grants. Do not take a blog's word for it, this one included: label a scratch workbook the way your client files are labelled, open the pane, and see. Then tell the firm the answer once, rather than letting six people discover it separately.
• AutoSave is not the gate people think. You will read everywhere that Copilot requires AutoSave and therefore OneDrive. Microsoft's current Copilot in Excel tips page says the opposite — it runs in workbooks with autosave enabled or disabled — while older Microsoft pages still say otherwise. Verify on your own tenant before rearranging your file storage on the strength of a forum post.

Sort them before you escalate any of it, because two of these are support tickets and two are conversations with a partner:

Which leaves an uncomfortable summary for a practice: on a properly run engagement file — checked out of the document system, classified, and built by somebody who turned calculation off — you may be several gates away from an assistant you are paying for per seat per month. That is the number the buying section at the end has to survive.

If somebody on the team is still looking for =COPILOT()

Someone in the firm will have read about a worksheet function and be hunting for it. It is a different product from the pane, and it is gone.

=COPILOT(prompt_part1, [context1], [prompt_part2], [context2], ...)

Under message centre notice MC1454373, from 14 September 2026 the =COPILOT function is no longer available and no new formulas using it can be created. It shipped in August 2025, never left the Frontier and Microsoft 365 Insider preview programmes, and lasted about a year. If Excel does not recognise the name, that is why, and no setting brings it back; the Copilot side pane is Microsoft's replacement for the same jobs. What a live AI function does to a working paper — and why Microsoft told you not to use it for anything with legal, regulatory or compliance implications — is covered properly in what Microsoft Copilot in Excel can't do for accountants, which owns that argument so this page does not have to repeat it.

The partner reviewing on an iPad gets a different product

The complaint arrives as "Copilot cannot even edit a workbook", and it usually arrives from whoever reviews on a tablet on a train. Copilot in Excel is, per Microsoft's FAQ, "available across platforms, including Excel on Windows, Mac, the web, iPad, iPhone, and Android" — but the capability is not level. Edit, plan and chat work on Windows, Mac and the web; iPad gets chat and plan, with edit rolling out; iPhone and Android get chat only. If someone tested on a phone and concluded the product does not work, that is the platform talking, and it is worth saying so before the firm draws a conclusion from it.

There is also one case where the web is the only option, and it is the direct consequence of the check-out gate above: where your organisation requires check-out for editing in SharePoint, Microsoft states Copilot on Windows or Mac will not work for files from that site. Read that as a firm-level conflict rather than a tip. If your document system enforces check-out — which is most of the reason to have one — then desktop Excel, the place your staff actually work, is the one environment where Copilot cannot touch those files, and Excel on the web, which few accountants use for real modelling, is the one where it can. There is no configuration that resolves that; there is only a decision about which of the two you value, and it is a decision for whoever owns the document system, not for the person with the empty corner of the grid.

What to tell the partner asking whether to buy it for everyone

If the label says Copilot Chat, stop troubleshooting. No registry key, ribbon reset or reinstall adds Copilot to a plan that does not carry it, and the pages promising otherwise are wasting your afternoon. The question becomes commercial, and it lands on a partner who wants a one-line answer.

The one-line answer is: not for everyone, and work out who before you count seats. The add-on is priced per seat per month, so buying it firm-wide is a recurring cost you will be looking at again next year. Split the staff list three ways. Preparers doing analysis — the people cleaning a bank export, building a summary from a messy download, writing a formula they half-remember — get real value, because that is the work Copilot is genuinely good at. Reviewers get much less: reviewing is reading someone else's file and deciding whether to sign it, and a chat pane does not do that for you. Anyone whose entire day is spent in engagement files that are checked out, classified and set to Manual calculation may find the pane is gated shut on the exact files they open, in which case you would be buying a licence for a workbook they cannot use it on. Test that with one seat before you buy forty.

Then ask the question underneath the question, because it is often the real one. A good deal of what a practice hopes Copilot will fix is not an Excel problem at all: it is that the numbers arrive in the wrong shape, from an accounting system, as a download somebody re-formats by hand every month. No amount of assistant in the grid changes where the data came from. If the complaint is "it takes half a day to get the ledger into a usable state", that is an export problem, and it is cheaper to fix upstream.

Before the purchase order, the cheaper options, in order. Use Copilot Chat on the web — if your business plan is Copilot Chat-eligible you already have it at m365copilot.com, and uploading a workbook to it costs nothing extra. Ask a free chatbot for the formula and place it yourself; for a single SUMIFS or a tricky nested IF, that is most of the value. Learn the tool that solves the underlying problem — a great deal of what people want Copilot for is repetitive cleanup that Power Query does deterministically, for free, and reproducibly next month. Only then buy a licence: consumer means a Personal, Family or Premium subscription; business means the Microsoft 365 Copilot add-on on top of an eligible plan, with current prices on Microsoft's pricing pages and the SKU-by-SKU breakdown in our guide to AI in Excel for accountants.

Be clear about what you are buying. Copilot in Excel is a good Excel assistant — summaries, charts, PivotTables, formulas, cleanup. It is not an accounting assistant: Microsoft documents no connector to QuickBooks, Xero or any other ledger, and nothing it produces goes back to one. If that gap is your real problem rather than the missing button, the wider field of AI Excel tools and the routes to running Claude inside Excel cover the non-Microsoft options. Ours is one of them, and its constraints matter more than its features here: HISAB 360 is a paid add-in for Windows desktop Excel only — no Mac, no Excel on the web, which is exactly where Copilot does work. It is not a Copilot substitute for general spreadsheet help; it is a chat panel with two-way connections to five accounting systems. If you simply wanted a smarter Excel, buy the Microsoft licence.

Frequently asked questions

Try HISAB 360 on your own workbook

HISAB 360 is an AI assistant inside Excel for accountants and finance teams — it writes macros, Power Query and formulas from plain English, and connects two-way to QuickBooks, Xero, Zoho Books, Odoo and FreshBooks. The 15-day trial is the full product, no card required.