Showing posts with label SharePoint Online. Show all posts
Showing posts with label SharePoint Online. Show all posts

Thursday, July 12, 2018

Excel Online error - we are sorry we couldn't open your workbook it is possibly corrupt or using a file format is not supported


I am seeing an error when I try to open Excel file in SharePoint Office Excel with error message “Excel Online error - we are sorry we couldn't open your workbook it is possibly corrupt or using a file format is not supported” as shown the image below.



I have verified excel file is corrupt and external data is loading from anywhere. But File looks good and there is no external data loading to the site.
After checking some posts, I found that it is due to protected mode enabled in the excel file. To fix the error, we have follow the steps below.
Download the document and open it in excel
Open the document in excel and uncheck all the options under Protected View. Go to file->options->Trust Center->Trust center settings->click protect view and uncheck all options under protected view. Then upload the document to the library to check if the same issue will occur.


By default, it will open excel file in excel online when storing the excel file in SharePoint online. Save and upload the excel in the Library. Try to open the file in Excel web app.