You open an Excel file from your local hard drive and click the Copilot button. Nothing happens, or you see an error that Copilot is not available for this workbook. This is not a bug or a temporary glitch. Copilot in Excel requires a cloud-connected file saved to either OneDrive or SharePoint to function. This article explains the technical reason for this restriction, provides the exact steps to move your file to a supported location, and covers related failure patterns you may encounter.
Key Takeaways: Moving Local Excel Files for Copilot Access
- File > Save As > OneDrive or SharePoint: Moves the file to a cloud location so Copilot can index and query the data.
- Microsoft 365 admin center > Settings > Copilot > Data sources: Controls which Microsoft Graph data Copilot can read for grounded responses.
- File format .xlsx: Copilot only works with the standard .xlsx format, not .xls or .csv files.
Why Copilot Requires a Cloud-Based Excel File
Copilot in Excel does not read the file directly from your local disk. Instead, it relies on the Microsoft Graph API to access the workbook content. The Microsoft Graph API is a unified endpoint that indexes and surfaces data stored in Microsoft 365 cloud services such as OneDrive, SharePoint, and Teams. When you open a file saved locally, Excel cannot pass the file path to the Graph API because the API has no visibility into your local file system.
The Copilot feature uses the same semantic index that powers search and recommendations across Microsoft 365. This index is built only for files stored in the Microsoft cloud. A local file on your C: drive is never scanned or indexed by Microsoft Graph. Therefore, Copilot cannot generate formulas, analyze data, or answer questions about a workbook that exists outside the cloud.
Another factor is the file format. Copilot works exclusively with the .xlsx format. Older formats such as .xls, .xlsb, and .xlsm are not supported. Even if you save a .xls file to OneDrive, Copilot will not activate for that workbook. You must convert it to .xlsx first.
Steps to Enable Copilot by Moving Your File to the Cloud
Follow these steps to move a locally stored Excel file to OneDrive or SharePoint so Copilot can access it.
- Open the local file in Excel
Launch Excel and open the workbook from your local drive using File > Open or by double-clicking the file in File Explorer. - Save the file to OneDrive
Go to File > Save As. Select OneDrive – Your Company Name from the list of locations. If you do not see OneDrive listed, click Add a Place and sign in with your Microsoft 365 work or school account. - Choose or create a folder
Navigate to an existing folder or click New Folder to create a dedicated folder for Copilot workbooks. Name the folder something descriptive, such as Copilot Data. - Confirm the file format is .xlsx
In the Save As dialog, check the Save as type dropdown. It must show Excel Workbook (.xlsx). If the file is an older format, change the type to Excel Workbook before saving. - Close and reopen the file from the cloud location
Close the workbook. Open Excel again, go to File > Open, and select the file from your OneDrive or SharePoint location. Do not open it from a local copy or a download folder. - Activate Copilot
Select any cell in the data table. On the Home tab, click the Copilot button. If the button is still grayed out, ensure your Microsoft 365 license includes Copilot and that the file is not marked as Read-Only.
If Copilot Still Has Issues After Moving the File
Copilot button remains gray or shows Not Available
The most common reason is that the workbook is not saved to a Microsoft cloud location. Double-check the file path in the title bar. If it shows a local drive letter such as C: or a network share path without sharepoint.com or my.sharepoint.com, repeat the steps above. Also verify that the file is not in a zip folder or a synced local folder that is not fully uploaded. Open the OneDrive or SharePoint web interface to confirm the file exists there.
Copilot returns Generic Output Instead of Tenant-Specific Data
This happens when the Microsoft 365 admin has not enabled Copilot for the tenant or has restricted data sources. Go to the Microsoft 365 admin center at admin.microsoft.com. Navigate to Settings > Copilot > Data sources. Ensure that Microsoft Graph data is selected. If it is disabled, Copilot cannot read any workbook content, even from OneDrive.
Copilot does not respond to natural language queries about the data
The workbook must have data formatted as a table. Select your data range and press Ctrl+T to create a table. Give the table a meaningful name in the Table Design tab, such as SalesData. Copilot uses the table name to understand the context. Without a named table, Copilot may not recognize the data structure.
Copilot in Excel for Local Files vs Cloud Files: Key Differences
| Item | Local File (Not Supported) | Cloud File (Supported) |
|---|---|---|
| File location | C: drive, external drive, network share without SharePoint | OneDrive or SharePoint site |
| Microsoft Graph indexing | Not indexed | Indexed automatically |
| Copilot availability | Grayed out or error message | Fully functional |
| File format required | Any format; Copilot will not activate | .xlsx only |
| Multi-user collaboration | Single user, no co-authoring | Co-authoring supported |
| Admin policy control | Not applicable | Controlled by Copilot data sources policy in admin center |
Conclusion
You now know that Copilot in Excel requires a cloud-based file because it depends on the Microsoft Graph API for indexing and querying workbook data. The fix is straightforward: save your local file to OneDrive or SharePoint using File > Save As, ensure the format is .xlsx, and reopen it from the cloud location. If Copilot remains unavailable, check the file path in the title bar and verify your admin has enabled Copilot data sources. For advanced use, try creating named tables in your workbook before asking Copilot to generate formulas or summaries. This gives Copilot the clearest context for accurate responses.