No Ticket Needed

Appearance

Understanding Why Copilot Only Works in Excel for the Web (and How to Fix It)

Applies toExcel
4 min read Updated 14 Aug 2026

By , 10+ years in IT support and helpdesk How these guides are checked

Quick Answer

Copilot in Excel currently requires your data to be stored in OneDrive or SharePoint, not saved locally. If Copilot is grayed out in desktop Excel, upload your file to OneDrive first, then reopen it from there.

Checked against Microsoft 365 Roadmap, Office release notes - Current Channel and between 5 Aug 2026 and 12 Sep 2026. Nothing published in that period has been linked to this guide.

Corrected 14 Aug 2026. This guide said Copilot in desktop Excel requires AutoSave to be on. Microsoft's August 2026 release notes state Copilot now works in cloud-saved workbooks with AutoSave turned off, rolling out on Windows and Mac, and the guide has been corrected. Files still have to live in OneDrive or SharePoint. Every correction to this guide →
Estimated Time to Fix: 3 minutes

Summary ​

Many users with a new Microsoft Copilot license get frustrated when they open the Excel desktop app and find the Copilot button grayed out or entirely missing, but when they open the exact same file in Excel for the Web, it works perfectly. This leads to the myth that "Copilot only works on the web." It actually works in both places, but the desktop app is much stricter about three specific requirements.

Before You Start ​

  • You must have an active Microsoft Copilot license assigned by your company.
  • You need both the Excel Desktop app and access to Excel for the Web.

Instructions ​

Why is it Grayed Out in the Desktop App? ​

Excel for the Web naturally forces you to save your files in the cloud. The desktop app does not. Microsoft Copilot is a cloud-based AI; it physically cannot read a file that is sitting solely on your computer's local hard drive (C:\).

If Copilot is working for you in the web browser but is grayed out in the desktop app, you are violating one of these three strict rules:

Rule 1: The File Must Live in the Cloud ​

If you opened a file directly from an email attachment, or if it is saved to your local Downloads or Desktop folder, Copilot cannot see it.

  • The Fix: Save the file to your company OneDrive or a SharePoint site.
  • Check the top of the Excel window. If the AutoSave toggle in the top-left corner is Off, your file may be saved locally — save it to OneDrive. AutoSave itself stopped being a requirement in the August 2026 updates (rolling out on Windows and Mac): Copilot works in cloud-saved files with AutoSave off, and Excel reminds you to turn it on before Copilot makes changes so unsaved work stays protected. On versions without that update yet, Copilot still needs AutoSave on.

Rule 2: The Data Must be a "Table" ​

Copilot cannot analyze random clusters of data scattered across a spreadsheet. It needs defined boundaries so it knows exactly what to read.

  • The Fix: Click anywhere inside your data, press Ctrl + T on your keyboard, and click OK. This turns your data into an official "Excel Table" with filter dropdowns at the top. Copilot will instantly light up.

Rule 3: The File Must be a .XLSX ​

If you are working with an older Excel file format (.xls) or a raw data export (.csv), Copilot will refuse to run.

  • The Fix: Click File > Save As and change the file type to Excel Workbook (*.xlsx).

Why Does it Seem to "Work" on the Web? ​

When you use Excel for the Web (excel.office.com), you are already uploading the file to Microsoft's servers to open it. Because it is already in the cloud, Rule 1 is automatically satisfied. If your data isn't a table, Excel for the Web will sometimes prompt you to convert it automatically when you click the Copilot button, whereas the desktop app grays the button out.

Troubleshooting ​

TIP

If you have verified the file is a .xlsx, saved in OneDrive, formatted as a Table, and the button is still missing in the desktop app, your desktop app license is out of sync.

Symptom / ErrorPotential CauseSolution
I did all three rules but the button is missing completelyLicense sync issueGo to File > Account and click Update License. Close Excel and reopen it.
Copilot says "I can't analyze this data right now"File too largeCopilot currently struggles with massive datasets (over 2 million cells). You may need to summarize the data first.

Last updated:

Frequently asked questions

Why does Copilot in Excel require my data to be formatted as a Table?
Excel spreadsheets can be chaotic. Formatting data as an official Table (Ctrl+T) gives the data clear boundaries and headers, which the AI requires to accurately understand the context of the numbers.
Can I use Copilot on an Excel file saved to my C: drive?
No. Copilot relies on the cloud to process data, and the file must be saved in OneDrive or SharePoint before the button activates in the desktop app. AutoSave no longer has to be on: in the August 2026 updates (rolling out on Windows and Mac), Copilot gained support for cloud-saved files with AutoSave turned off — Excel reminds you to turn it on before Copilot makes changes, so unsaved work stays protected.