Copilot Not Showing in Excel? The Fix List

Copilot now opens from a single floating button in the lower-right corner of the document. Microsoft calls it the Copilot Dynamic Action Button (catchy, I know). The worldwide rollout ran from April to June 2026. Microsoft says government clouds (GCC, GCC High and DoD) see it starting in October 2026.

Microsoft is clear that the capabilities didn't change. Only the way you open it did.

Try the keyboard before anything else. F6 works on every platform. Alt+C on Windows and Cmd+Control+I on Mac are rolling out across apps and languages.

Miss the ribbon? Right-click the button and choose Move to ribbon. You need Windows build 16.0.20129.15140 or later, or build 16.109.525.2 or later on a Mac. You can also right-click and choose Dock, or drag the button to the side of your content. In right-to-left locales, Microsoft says that side is the left.

Steps online not matching your screen? Microsoft refreshed the Copilot panes in Word, Excel and PowerPoint in October 2026, so older screenshots may look different.

No access, no button. Microsoft says the button only appears for people who have Copilot, and Copilot in Excel needs one of these:

Not sure which one you have? Microsoft defines 3 labels: M365 Copilot (Premium), M365 Copilot (Basic) for standard access, and Copilot Chat (Basic), which means no access to Copilot in Word, Excel, PowerPoint and OneNote. To see yours, sign in to Microsoft 365 with your work or school account and scroll to the bottom of the home page.

Copilot Chat (Basic) is behind a change from this spring. Microsoft announced it in Message Center posts MC1253858 and MC1253863. On 15 April 2026 it removed Copilot from Word, Excel, PowerPoint and OneNote for Copilot Chat users, meaning people without a paid licence. Reports put the line at around 2,000 Microsoft 365 users. That number isn't on a public Microsoft page, so treat it as reported. Copilot vanished in April and you have no paid licence? Check your label, because this is a likely reason.

Separate from April: fair use limits (yes, another change). Message Center posts MC1536158 and MC1536163 (3 November 2026) set new limits on Copilot Chat in apps for unlicensed users in commercial tenants. MC1536158 says they're rolling out, and MC1536163 gives 9 November as the start. Microsoft doesn't publish numbers. The posts don't name Excel, so a missing button is not automatically a limit.

One more for IT: Copilot isn't available with device-based licensing for Microsoft 365 Apps for enterprise.

On Windows, go to File > Account and select Update License. Then close and restart all your Microsoft 365 apps, not only Excel.

On a Mac, open the app menu, choose About, then More Info, then Refresh License.

While you're on File > Account, look at which account Excel is signed in with. Microsoft lists being signed in with both a personal and a work or school account as a cause, because Copilot might not validate correctly. It looks exactly like a missing licence. Use just the one account and restart.

Licence assigned today? Microsoft says a new assignment can take some time to propagate, and the symptoms include the button not appearing or being greyed out. The same page lists Couldn't update license, Error code: 29. If you see that, work through this list, then ask your admin.

Did you reset or update Office recently? Microsoft lists that as a cause too, because it can affect your activation status. Run Update License again.

Step 1 on Microsoft's own list is making sure you're on the latest build. Update, restart, look again.

In companies, the update channel is the quiet killer. On the Semi-Annual Enterprise Channel, Microsoft says Copilot features simply aren't available in your apps. You need Current Channel or Monthly Enterprise Channel, and that's an IT decision.

Here's a fast test. Excel for the web doesn't depend on the update channel. If Copilot shows up when you open the same file in the browser, the licence is probably fine and the desktop app is the likely problem.

On Windows, go to File > Account > Account Privacy > Manage Settings. Microsoft names 2 settings that can hide Copilot: Experiences that analyze your content, and All connected experiences. Both need to be on.

On a Mac, Microsoft points you to the Privacy section under Preferences. On a managed work laptop you may not be allowed to change these, so ask IT.

Web: blocked third-party cookies stop Copilot from validating your licence. If it isn't working in the browser, allow third-party cookies and reload.

Mac: same modes as Windows (edit, plan and chat), so a missing button there is a licence, build or privacy issue from the list above.

iPad, iPhone and Android: expect less. Microsoft's support pages list chat and plan modes for iPad and chat for iPhone, with edit mode still rolling out to both. For Android they list chat. So Copilot answering on your phone but refusing to edit the sheet is normal, not a bug.

Language: Hebrew is on Microsoft's supported-language list for Copilot in Excel. Microsoft adds a caveat: Copilot was trained on sources predominantly in English and may not perform as well in other languages.

If the button is there but Copilot can't work on the file, check the file before the licence:

AutoSave doesn't have to be on: Microsoft says Copilot runs with AutoSave on or off. Where the file lives is less settled. Microsoft's FAQ, tips and get-started pages state no storage rule. Its screen-reader tutorial (28 September 2026) says Copilot works with workbooks stored in OneDrive or SharePoint, and that a local file or unsupported format will limit or disable it. So if Copilot is missing on a file saved on your computer, save a copy to OneDrive or SharePoint as .xlsx and try again. That is the safest fix.

Excel Table formatting isn't a listed requirement either, whatever older guides say.

It answers but never changes the sheet: check the mode. Excel opens in edit mode by default, and chat mode never makes changes. (Older guides call edit mode Agent Mode. Microsoft folded that into the regular Copilot experience.)

Greyed out, or Unsupported file state: Calculation is on Manual, or the file is checked out in SharePoint.

Strict Open XML, or a file saved only on your computer: save it as .xlsx in OneDrive or SharePoint.

A DKE file is open: Copilot can't be used in the app while it is.

Those are the file-level blockers Microsoft documents. I found no per-file off switch.

Add *.cloud.microsoft to your allow lists on devices and the network, and don't allow only selected URLs inside that domain, because Microsoft doesn't support that. Then verify full WebSocket Secure (WSS) connectivity to *.office.com, *.cloud.microsoft and copilot.cloud.microsoft. Copilot can fail when a perimeter blocks WSS, when TLS inspection interferes with the connection, or when a proxy enforces aggressive timeouts.

The Office Feature Updates task must also run on its regular schedule and reach the required network resources. And admins can't switch off Copilot in Excel on its own: it follows the Copilot Chat admin settings. Microsoft's Copilot License Details diagnostic shows whether a user meets the licensing requirements.

Once it's back, here are Copilot prompts for Excel that actually work. If your team relied on the retired formula, read what replaced Excel's COPILOT function. And for the full picture, my guide to Copilot in Excel.

If everyone can see the button and still nobody uses it, no setting will fix that. That part is my job. (I have no commercial interest in Microsoft, just in teams that actually use what they pay for.)