Copilot in Excel Not Showing or Greyed Out? 7 Fixes That Actually Work (2026)
Copilot missing or greyed out in Excel? Learn 7 simple, step-by-step fixes for OneDrive, table formatting, licensing, and privacy settings to restore AI in 2026.
MICROSOFT EXCEL
In this article, we’ll look at why Copilot is not showing or is greyed out in Excel, and which fixes are effective in 2026.
You open Microsoft Excel expecting to use Copilot, but something doesn’t look right. Maybe the Copilot button isn’t there at all, or it is there but greyed out and won’t respond. Copilot may be available in other applications such as Microsoft Word, which usually makes the situation more confusing for the customer.
It doesn’t mean Copilot is broken. Excel checks several things before enabling Copilot, including your Microsoft 365 subscription, account, Excel version, file location, file format, AutoSave status, and the structure of your spreadsheet.
In this guide, we’ll go through 7 practical fixes, starting with the easiest ones. In many cases, you can solve the problem with the first one or two checks.
Why this happens
There isn’t a single reason why Copilot might not work in Excel. The problem usually comes from one of three areas:
1. Your plan. Copilot isn’t automatically available in every Microsoft 365 plan. You might have a Microsoft account and a perfectly working copy of Excel, but that doesn’t mean your account has access to Copilot. Microsoft has changed how Copilot access is included with some plans, and availability can change over time, so the first thing to verify is whether the account you’re using in Excel actually has Copilot access.
2. Your workbook. Even if your account has access to Copilot, Excel also looks at the workbook you’re currently using. Copilot may work in Word but not in Excel, which doesn’t mean your subscription is inactive. Excel checks where the file is saved, whether AutoSave is enabled, whether your data is structured properly, and which file format you’re using.
3. Your Excel setup. An outdated version of Microsoft Office, a licensing problem, incorrect privacy settings, or an issue with your Microsoft 365 sign-in can prevent Copilot from appearing or working correctly.
The 7 fixes
1. Check that your Microsoft 365 plan includes Copilot
This should be your first check. There’s no point in troubleshooting Excel settings if your account doesn’t have access to Copilot. Microsoft has changed its Copilot offerings over time, including updates made recently, so older articles about which plans include Copilot may no longer be accurate. Also make sure you’re not signed into Excel with a different account from the one that has your Microsoft 365 subscription.
2. Save the workbook to OneDrive and turn on AutoSave
If your file is stored only on your computer, Copilot may not be available for it. Save the workbook to OneDrive, then turn on the AutoSave toggle in the top-left corner of Excel. This applies even if the file is already saved somewhere on your PC. Move it to OneDrive first, then turn AutoSave on.
3. Turn your data into an Excel Table
This matters most when Copilot is available but doesn’t seem to understand your spreadsheet. Excel works better with structured data than with raw data. A table with properly labeled headers gives Excel a clear picture of your dataset, which makes it much easier for Excel’s AI features to work with it. Select your data and press Ctrl + T.
4. Refresh your Microsoft 365 license and sign in again
Sometimes everything looks correct, but Excel simply isn’t recognizing the license properly. This often happens after changing Microsoft 365 plans, renewing a subscription, switching accounts, or installing Microsoft 365 on another computer. Sign out of your account (File > Account > Sign out), close Excel, then reopen it and sign back in. This can refresh the licensing information.
5. Update Excel
An outdated version of Excel is another common cause. If you’ve confirmed that your subscription supports Copilot and your workbook meets the requirements, make sure Excel itself is up to date. AI features like Copilot can depend on newer versions of the Office apps and their supporting services. Go to File > Account > Update Options > Update Now.
6. Check your file type and privacy settings
If Copilot still isn’t working, check the details of your Excel environment. If you’re working with a CSV file, don’t assume you’ll get the same Copilot experience as with a normal Excel workbook. Save it as .xlsx first. Then go to your Excel account settings and review your privacy and connected-experience options (File > Account > Manage Settings) to ensure “Experiences that analyze your content” and “All connected experiences” are enabled.
7. Test in Excel for the web
This is one of the best last tests because it shows you where the problem actually is. Instead of continuing to change settings in desktop Excel, open Excel in your web browser, sign in to Microsoft 365, open the same workbook, and check whether Copilot is available there. If Copilot works on the web but not in desktop Excel, the issue is probably related to your desktop installation, Office version, local settings, update status, or Windows/device configuration.
Still not working?
If you’ve gone through all 7 fixes and the issue still persists, the problem may be outside your Excel settings.
· Personal account: Check Microsoft’s current service and support information for personal accounts, as availability and region limits can change.
· Work or school account: The cause could be admin settings, network blocks, or license assignment. Contact your IT department.
When you contact IT, don’t just say “Copilot doesn’t work.” Give them the details. Here’s a template you can copy:
Quick checklist
1. Make sure Copilot is included in your plan and assigned to your account
2. Turn on AutoSave
3. Select your data and press Ctrl + T
4. Sign out and back in to refresh your license
5. Install the latest Microsoft 365 updates
6. Use the .xlsx file type and review your privacy settings
7. Find out whether the problem is your desktop Excel installation or your account
FAQ
· Is Copilot in Excel free?
Generally no. Access depends on your Microsoft 365 plan, account type, licensing, and Microsoft’s current availability rules.
· Why is Copilot greyed out when I already have a table?
A table is only one requirement. Copilot can still be greyed out if AutoSave is off, the file isn’t saved to OneDrive, or your license isn’t recognized.
· Does Copilot work with CSV files?
CSV files open in Excel, but they don’t support the same workbook features as a native .xlsx file. Save your CSV as .xlsx first.
· Does Copilot work in Excel for the web?
Yes, when your account and environment support it.
Closing
When Excel Copilot disappears or becomes greyed out, don’t assume Excel is broken. Troubleshoot the problem systematically. The goal isn’t just to make Copilot appear. It’s to identify why it wasn’t available in the first place.
Excel Pro Hub © 2025
Excel tutorials, AI workflow guides, and freelance tips. —— Built for people who want to work less and earn more.
Reframe your inbox
Subscribe to our newsletter and never miss a story.
We care about your data in our privacy policy.
Follow us