Copilot Not Showing in Excel? The Fix List
Bottom line: look at the lower-right corner of your workbook first. Between April and June 2026 Microsoft moved the Copilot button off the ribbon and into that corner, and Microsoft's own troubleshooting page opens with "The button moved, so it might not be missing." If it really isn't there, Microsoft lists the most common causes as your licence, your Excel build, your update channel and your privacy settings.
Go through the list below in order. You can do the first 3 checks yourself in a few minutes, before anyone needs to open a ticket.
Where is Copilot in Excel? It moved to the corner
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. Government clouds (GCC, GCC High and DoD) get it from 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 to park it next to your content.
Check that you actually have access
No access, no button. Microsoft says the button only appears for people who have Copilot, and Copilot in Excel needs one of these:
1Microsoft 365 Personal or Family, with an AI credits plan
Home users on these plans may also have switched Copilot off themselves, with the Enable Copilot checkbox in the app settings. Tick it back on.
2Microsoft 365 Premium
The consumer plan that includes Copilot.
3A commercial Copilot licence
Microsoft 365 Copilot, now renamed Microsoft Copilot. In the app you'll see it labelled M365 Copilot (Premium), with priority access.
4A Copilot Chat-eligible business or enterprise subscription
Labelled M365 Copilot (Basic). That's standard access, which depends on service capacity and can be restricted temporarily at busy times.
And one change from this spring hits big companies. On 15 April 2026 Microsoft removed the free Copilot Chat from Word, Excel, PowerPoint and OneNote for users without a paid licence in large organisations. Reports put the line at more than 2,000 Microsoft 365 users, but that number isn't in Microsoft's public docs, so treat it as unconfirmed. If you're in a big company, have no paid licence and Copilot vanished in April, this is the most likely reason.
One more for IT: Copilot isn't available with device-based licensing for Microsoft 365 Apps for enterprise.
Refresh the licence, and check the account
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. The licence belongs to one account, and a personal login in a work copy of Excel (or the other way around) looks exactly like a missing licence.
Update Excel and check the update channel
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 fine and the desktop app is the problem.
Turn connected experiences back on
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.
Excel for the web, Mac and mobile
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. iPad has chat and plan modes, iPhone has chat, and edit mode is still rolling out to both. Android has chat only. So Copilot answering on your phone but refusing to edit the sheet is normal, not a bug.
Copilot greyed out, or it won't edit the file
If the button is there but Copilot can't work on the file, check the file before the licence:
1Calculation set to Manual
Copilot only edits when Calculation Options are set to Automatic. Formulas > Calculation Options > Automatic.
2Checked out in SharePoint
A checked-out file gives you an Unsupported file state message. If your SharePoint site requires check-out for editing, Copilot on Windows or Mac won't work for files from that site.
3The wrong file format
Strict Open XML fails. So did .csv and .xls files stored locally, at least when local-file support reached Insiders in February 2026. Save as a regular Excel Workbook (.xlsx) and try again.
What you can stop worrying about: Microsoft's current docs say Copilot runs with AutoSave on or off, and no longer list OneDrive storage or Excel Table formatting as requirements. Plenty of older guides still say otherwise.
For IT: the network and admin checks
Add *.cloud.microsoft to your allow lists, and make sure your network handles WebSocket (WSS) connections. Microsoft warns that badly configured WSS can make Copilot fail. And admins can't switch off Copilot in Excel on its own: it follows the Copilot Chat admin settings, so check those.
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.)
Questions about Copilot not showing in Excel
Why is Copilot not showing in Excel?
Microsoft says it is usually one of 2 reasons: the button moved to the lower-right corner of the workbook, or your account or licence needs attention. Microsoft lists the most common causes as your licence, your build, your update channel and your privacy settings.
Where is Copilot in Excel now?
In the lower-right corner of the workbook, as a floating Copilot button. F6 opens it on every platform, and you can move it back to the ribbon by right-clicking it and choosing Move to ribbon.
How do I enable Copilot in Excel?
You need an eligible licence first. Then update Excel, select Update License under File > Account, make sure you are on Current Channel or Monthly Enterprise Channel, and turn on connected experiences in the privacy settings.
Why is Copilot greyed out in Excel?
Check that Calculation Options are set to Automatic, that the file is a regular .xlsx and not Strict Open XML, and that it is not checked out in SharePoint. Users with standard access can also be restricted temporarily at busy times.
Can I use Copilot in Excel without a paid licence?
Some business users get standard access through Copilot Chat, labelled Basic, which can be limited at busy times. Unlicensed users in large organisations lost Copilot inside Excel on 15 April 2026. Personal and Family subscribers need an AI credits plan.
Does Copilot in Excel still need OneDrive and AutoSave?
No. Microsoft's current docs say it runs with AutoSave on or off, and they no longer list OneDrive as a requirement. If a local file gives you trouble, save it as .xlsx.
The button is back. Now make it earn its licence.
I run live online Copilot workshops for groups of up to 20 people, from 1.5 to 4 hours. Teams that live in Excel have their own session.