Sharepoint couldn't open the workbook

When it is not possible to open a workbook directly from Sharepoint, a solution is to download the file locally first, and open it afterwards, instead of having it being opened on Excel online from the online Sharepoint.

We're sorry we couldn't open your workbook Sharepoint 2013

When it is not possible to open a workbook directly from Sharepoint, a solution is to download the file locally first, and open it afterwards, instead of having it being opened on Excel online from the online Sharepoint.

Unable to open excel files from Sharepoint

When the Couldn't open the workbook error happens, for example with the message Sorry, we can't open your workbook in Excel Online because it exceeds the file size limit. You'll need to open this in Excel. In that case, the safest option, instead of opening from Sharepoint, is to first download the file.

The first thing to try, is to download directly the workbook on Excel from Sharepoint, by using the Open in Excel button on the error popup.

After that, a Microsoft security message will most likely show up, saying that the file will be opened outside of the Protected mode, locally on the computer. Simply allow this file to be downloaded, provided that you do trust the source.

Again, Microsoft Office itself might ask for another extra confirmation, as some files contain viruses that can be harmful to your computer. If you trust the source of the file, again, click Yes to start the download in order to open the file locally in Excel.

Excel will be opened, and, if the file is protected by Sharepoint user control, a pop up will show up asking to sign in, even if the user was already signed in on Sharepoint, and his access has already been confirmed.

Enter the email that has access rights to the file, and, after that, the corresponding password in case it hasn't been remembered on the computer.

File from Sharepoint

The file will then open in Excel, and a download progress bar will be visible in the status bar of Microsoft Excel, in the green part of the window bottom.

Sharepoint 2013 file size limit

Sharepoint has a file size limit, above which it is not possible to open files directly from the online applications, especially MS Excel workbooks.

The Sharepoint limitations depends both on software and on server configuration.

For Sharepoint 2013, the general Sharepoint max file size file size limit is 250MB, and for Sharepoint Online, it can go up to 10GB. However, these limits must be checked with the system administrator, as they depend on the local configuration and software versions.

Ultimate guide to Sharepoint size and usage limitations

Become an Excel Pro: Join Our Course!

Elevate your skills from novice to hero with our Excel 365 Basics course, designed to make you proficient in just a few sessions.

Enroll Here

Elevate your skills from novice to hero with our Excel 365 Basics course, designed to make you proficient in just a few sessions.

In that case, if the file cannot be opened from Microsoft Sharepoint, then, go on the file location on Sharepoint, click on the three dots next to the file name, click again on the three dots in the popup to open the extra options, and select download.

The file will then be downloaded locally on the computer, and can be opened on the local Microsoft Excel software installation.

Sorry, we're having a problem showing this workbook

The error saying sorry we're having a problem showing this workbook might happen when the file is too large, or is protected by a password for example.

In that case also, start by downloading the file locally before opening it.

Sharepoint team collaboration software tools

Sorry we couldn't open Excel file SharePoint

When getting the SharePoint error Sorry we couldn't open Excel file, one solution is to try to delete the cache from Microsoft Office Upload Center.

Open the Microsoft Office Upload Center > settings > delete cached files > OK.

After the cache has been cleared, Excel file on SharePoint should open again.

Another solution is to delete the cache manually, by deleting all files located in folder %userprofile%\AppData\Local\Microsoft\Office\15.0\OfficeFileCache\ which contains the Microsoft Office cached files.

Frequently Asked Questions

What troubleshooting steps can be taken when SharePoint is unable to open a workbook, ensuring users regain access to their documents?
Ensure the workbook is not corrupted and is saved in a compatible format. Check SharePoint and Excel Services configurations for allowed file sizes and trusted locations. Additionally, verify that the SharePoint server is properly configured to use Excel Services for opening workbooks.

Yoann Bierling
About the author - Yoann Bierling
Yoann Bierling is a Web Publishing & Digital Consulting professional, making a global impact through expertise and innovation in technologies. Passionate about empowering individuals and organizations to thrive in the digital age, he is driven to deliver exceptional results and drive growth through educational content creation.

Become an Excel Pro: Join Our Course!

Elevate your skills from novice to hero with our Excel 365 Basics course, designed to make you proficient in just a few sessions.

Enroll Here

Elevate your skills from novice to hero with our Excel 365 Basics course, designed to make you proficient in just a few sessions.



Comments (0)

Leave a comment