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.
