How to Fix Excel Online Workbook Not Opening from SharePoint
Question details
Excel attachments stored in SharePoint lists fail to open in Excel for the web, displaying an error message.
- Product
- Excel Online / SharePoint
- Device & OS
- not provided
- Scenario
- Attempting to open an Excel workbook attached to a SharePoint list using Excel for the web.
- Observed behavior
- The workbook fails to open, displays a 'The workbook cannot be opened' error, and may only be viewable in read-only mode.
Ensure you have a stable internet connection and the necessary permissions to access and edit files within the target SharePoint list.
Check the Microsoft 365 Service Health Dashboard
Determine if a global or tenant-specific SharePoint Online service incident is causing the issue.
Often, workbook access issues in SharePoint are caused by backend Microsoft 365 service incidents rather than damaged files. For example, incident SP411415 historically prevented users from opening Excel attachments from SharePoint lists.
Ask your tenant administrator to log in to the Microsoft 365 admin center.
Go to Health > Service health in the navigation menu.
Look for any active advisories or incidents related to SharePoint Online or Excel Online that might explain the workbook access failures.
Test Access Using Alternative Methods
Rule out browser-specific caching issues or web application glitches.
Contact Microsoft Support
Escalate the issue if no service incident is reported and the file is verified as intact.
Edit Spreadsheets Locally with WPS Office
If SharePoint and Excel Online are experiencing service outages, WPS Office serves as a reliable, free, and lightweight alternative to open and edit your downloaded Excel workbooks locally. It provides robust offline capabilities so your productivity isn't halted by cloud synchronization issues.
- 1. Download the Excel File: Download the problematic Excel attachment from SharePoint to your local drive.
- 2. Install WPS Office: Download and install the free WPS Office suite on your device.
- 3. Open and Edit Locally: Right-click the downloaded workbook, select 'Open with WPS Office', and edit your data offline without relying on Excel Online.
Frequently Asked Questions
Why does my SharePoint Excel file say 'The workbook cannot be opened'?
This error is frequently caused by Microsoft 365 service incidents (such as server-side synchronization issues in SharePoint Online), temporary browser cache conflicts, or insufficient file permissions, rather than actual file corruption.
How do I check for SharePoint service outages?
Tenant administrators can check the Microsoft 365 Service Health Dashboard within the Microsoft 365 admin center under the 'Health' section to see real-time updates on active incidents.
What should I do if the SharePoint file is urgent and won't open in the browser?
Download a copy of the attachment to your local computer. You can then open and edit the file using a desktop application like WPS Spreadsheet or Microsoft Excel until the cloud service is restored.
Can a corrupted file cause the Excel Online open error?
Yes, if the file itself is damaged during upload or saving, Excel Online will fail to read it. To test this, download the file locally; if it still fails to open in a desktop application, the file is likely corrupted.
