Copilot in Excel Cannot Read My Workbook: Causes and Fixes

You open Excel, type a prompt in Copilot, and it responds with an error that it cannot read your workbook. This stops you from using Copilot to analyze data, create charts, or write formulas. The problem usually happens because the workbook is in an unsupported format, has protected sheets, or Copilot lacks the required permissions. This article explains the main causes of this read failure and provides step-by-step fixes for each one.

Why Copilot Cannot Read Your Excel Workbook

Copilot in Excel relies on a structured data model that expects a modern file format and unrestricted access to all cells. When you save a workbook in a legacy format such as .xls or .xlsb, Copilot cannot parse the internal structure. The same happens when sheets are protected, because Copilot cannot modify or read locked cells. Additionally, Copilot requires that the workbook is stored in a location that the Microsoft Graph can access, such as OneDrive for Business or SharePoint Online. If the workbook is stored locally on your hard drive or in a non-synced folder, Copilot cannot open it.

Another common root cause is a missing or expired Copilot license. Even if the Copilot pane appears in Excel, the service will refuse to read the workbook if the license check fails. Finally, group policies or admin settings in the Microsoft 365 admin center can restrict which files Copilot can access. These policies are often set to prevent data leakage, but they can block legitimate use.

Unsupported File Formats

Copilot supports only .xlsx and .xlsm file formats. The .xls format from Excel 97-2003, .xlsb binary format, and .csv plain text format are not supported. If you open any of these unsupported formats, Excel may convert them to .xlsx automatically, but Copilot still sees the original structure and fails to read it.

Protected Sheets and Workbook Structure

When a sheet is protected, Copilot cannot read cell values, formulas, or named ranges. The protection is designed to prevent accidental edits, but it also blocks Copilot from analyzing the data. Workbook-level protection, such as a password to open the file, also prevents Copilot from accessing the content.

Missing Permissions and Licensing

Copilot in Excel requires a Copilot Pro subscription or a Copilot for Microsoft 365 license. Without these, the Copilot pane may appear but will not function. Additionally, the user must have at least Read access to the workbook file in OneDrive or SharePoint. If the file is shared with restricted permissions, Copilot cannot read it.

Steps to Fix Copilot When It Cannot Read Your Workbook

Follow these steps in order. After each step, test Copilot by typing a simple prompt such as “Summarize this data in a table.”

1. Save the workbook as .xlsx or .xlsm
   Open the workbook in Excel. Go to File > Save As. In the Save as type dropdown, select Excel Workbook .xlsx or Excel Macro-Enabled Workbook .xlsm. Choose a location on OneDrive or SharePoint. Click Save. Close and reopen the file before using Copilot.
2. Unprotect all sheets in the workbook
   Go to the Review tab. Click Unprotect Sheet. If the sheet is password-protected, enter the password. Repeat for every sheet. If the workbook itself has a password, go to File > Info > Protect Workbook > Encrypt with Password. Remove the password and save.
3. Move the workbook to a supported cloud location
   Copy the workbook to your OneDrive for Business folder or a SharePoint Online document library. Do not store it on a local drive or a network share that is not synced. In Excel, open the workbook from the cloud location using File > Open > OneDrive or Sites.
4. Verify your Copilot license
   In Excel, click your profile picture in the top-right corner. Select View Account. Under Subscriptions, confirm that Copilot Pro or Copilot for Microsoft 365 appears. If not, contact your IT admin to assign the license. Restart Excel after the license is assigned.
5. Check admin settings for Copilot data access
   Go to the Microsoft 365 admin center at admin.microsoft.com. Navigate to Settings > Org settings > Copilot. Under Data sources, ensure Microsoft Graph is enabled and that the setting “Allow Copilot to access all files” is turned on. If these settings are greyed out, ask your global admin to adjust them.
6. Clear the Excel cache and restart
   Close Excel. Press Windows key + R, type %appdata%\Microsoft\Excel and press Enter. Delete all files in the XLSTART folder. Also delete files in %localappdata%\Microsoft\Office\16.0\OfficeFileCache. Restart Excel and open the workbook again.

If Copilot Still Has Issues After the Main Fix

Sometimes the main fixes do not resolve the problem. Below are additional failure patterns and their specific solutions.

Copilot Returns Generic Output Instead of Tenant-Specific Data

If Copilot responds but gives vague answers like “I cannot find that information,” the workbook may contain unsupported data types. Copilot cannot read data from external connections, Power Query queries, or data models. Convert all external data into static tables. Select the data, go to Data > Queries & Connections, right-click each query, and select Load To > Table. Then copy the table and paste as values.

Copilot Does Not Appear in the Ribbon or Pane

If the Copilot button is missing entirely, the feature is likely disabled by group policy. Ask your IT admin to enable the policy “Allow Copilot in Excel” in the Microsoft 365 admin center under Settings > Org settings > Copilot. Also ensure that Excel is updated to version 2402 or later by going to File > Account > Update Options > Update Now.

Copilot Fails with “Workbook Is Too Large” Error

Copilot has a practical limit of about 1 million cells per workbook. If your file exceeds this, reduce the data. Remove unused rows and columns. Delete sheets that are not needed. Use Excel’s Data Model sparingly because Copilot does not read from it. After trimming, save as a new .xlsx file and test again.

Copilot in Excel Workbook Read Errors: Comparison of Causes

Cause	Error Message or Symptom	Fix
Unsupported file format .xls .xlsb .csv	“Copilot cannot read this file type”	Save as .xlsx or .xlsm
Protected sheets	“Copilot cannot access protected content”	Unprotect all sheets via Review tab
Missing Copilot license	Copilot pane is blank or shows a license error	Assign Copilot Pro or M365 license
File stored locally	“Copilot requires a cloud file”	Move to OneDrive or SharePoint
Admin policy blocks data access	“Copilot cannot access this organization’s data”	Enable Microsoft Graph in admin center
Workbook exceeds 1 million cells	“Workbook is too large for Copilot”	Trim data and remove unused sheets

After applying the correct fix, Copilot should read your workbook and respond to prompts within seconds. If you continue to see errors, check the Microsoft 365 service health dashboard for any ongoing Copilot outages. Also consider converting any legacy macros or add-ins that might interfere with Copilot’s data access. As a final step, use Excel’s built-in Accessibility Checker to ensure no hidden structural issues block Copilot from reading the workbook content.