Microsoft 365 Copilot Cannot Analyze Excel Table Error: Fix

You open an Excel workbook, select a formatted table, and ask Copilot to summarize or analyze the data. Instead of a result, you see an error message: Copilot cannot analyze this table. This problem usually occurs when the data is not structured as a proper Excel table or when Copilot lacks permission to read the content. This article explains the root causes of this error and provides clear steps to resolve it so you can use Copilot for data analysis in Excel again.

Why Copilot Cannot Analyze Your Excel Table

Copilot in Excel requires data to be in a structured table format. A structured table in Excel is a range of cells formatted using the Insert > Table command or the Ctrl + T shortcut. This format gives the range a defined header row and a unique table name. If your data is in an unstructured range, Copilot cannot identify column headers, detect data types, or generate accurate summaries. The error also appears when the workbook is stored in a location Copilot cannot access, such as a local drive without OneDrive sync, or when tenant-level admin policies restrict Copilot from reading the file.

Steps to Fix the Copilot Table Analysis Error

Follow these steps in order. After each step, test Copilot by selecting the table and asking a question like “Summarize this data” or “Show trends.”

1. Convert the data range to an Excel table
   Select any cell inside your data range. On the ribbon, go to Insert > Table. In the Create Table dialog, confirm the range and check the box “My table has headers.” Click OK. Excel assigns a default name like Table1.
2. Give the table a descriptive name
   Select any cell in the table. On the ribbon, go to Table Design > Table Name. Replace the default name with a short, unique name like SalesData. Use only letters and numbers, no spaces. Press Enter.
3. Save the workbook to OneDrive or SharePoint
   Copilot requires the file to be stored in a Microsoft 365 cloud location. Click File > Save As > OneDrive. Choose your work or school account. Name the file and click Save. If the file is already in a cloud location, skip this step.
4. Check that Copilot has permission to read the file
   Open the file in your browser at office.com. Click Share at the top right. Verify that the file is shared with your account and that you have at least Edit permissions. If the file is in a shared location, ask the owner to grant you Edit access.
5. Enable Copilot data access in the Microsoft 365 admin center
   Sign in to admin.microsoft.com. Go to Settings > Org settings > Copilot. Under Data permissions, select the option “Allow Copilot to access Microsoft Graph data.” Click Save. This setting gives Copilot permission to read workbook content. Changes take effect within 15 minutes.
6. Clear the Copilot cache in Excel
   In Excel, click File > Options > Trust Center > Trust Center Settings > Privacy Options. Under Privacy settings, click the button “Reset” next to “Reset the Copilot cache.” Click OK and restart Excel. This removes any stale data that may block analysis.
7. Test with a simple query
   Select any cell in the table. Open the Copilot pane by clicking the Copilot icon on the Home tab. Type “Show the total sales by region” or “List the average of column B.” If Copilot responds correctly, the fix is complete.

If Copilot Still Has Issues After the Main Fix

Copilot says “I cannot analyze this table” on a fresh table

This can happen if the table contains merged cells or blank columns. Remove all merged cells by selecting the table, going to Home > Merge & Center > Unmerge Cells. Delete any completely blank columns or rows inside the table range. Then select the table and press Ctrl + T again to recreate it.

Copilot analyzes the wrong data

If Copilot returns results from a different table or an unrelated sheet, it may be reading the wrong table. Ensure only one table exists in the active sheet, or explicitly select the correct table before asking a question. You can also name the table with a unique name as shown in Step 2 above.

Copilot does not appear in Excel at all

The Copilot button may be missing if your Microsoft 365 license does not include Copilot. Go to File > Account > Subscription. Look for “Microsoft 365 Copilot” in your license details. If it is not listed, contact your IT admin to assign a Copilot license. After the license is assigned, restart Excel.

Copilot returns “Access denied” or “Content not available”

This error indicates that the file is in a location Copilot cannot reach. Move the file to OneDrive or SharePoint. If the file is already there, check that the site is not blocked by a data loss prevention policy. Ask your admin to review Microsoft 365 admin center > Data loss prevention > Policies and verify that the site URL is not restricted.

Copilot Table Analysis: Structured Table vs Unstructured Range

Item	Structured Table	Unstructured Range
Definition	Range formatted with Insert > Table	Plain cells without table formatting
Header row	Always present and recognized	Not automatically detected
Table name	Unique name like SalesData	No name available
Copilot support	Full analysis and summarization	Error: cannot analyze this table
Example query	“Show total by region”	No response or error

To avoid this error on every new workbook, train your team to convert any new data range into an Excel table before using Copilot. This one habit prevents the error and unlocks all Copilot analysis features in Excel.