No Ticket Needed

Appearance

3 min fix 4 min read Recently reviewedBeginner

By , IT support technician

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.

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

Estimated Time to Fix: 3 minutes

Applies to: Microsoft Excel
Article Type: Informational
Last Updated: 2026-07-20

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.

Prerequisites ​

  • 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 you see the "AutoSave" toggle in the top-left corner is turned Off, your file is probably saved locally. Toggle it On and save it to OneDrive.

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.