Recently I uploaded a file in a document library on a SharePoint site. I had created a report and wanted to publish it. After reviewing client requested some changes in it, I tried to open that file from SharePoint directly in Microsoft Excel using “Open in Excel”.
Whatever I tried I always received an error “The file is corrupt and cannot be opened”. Did a little search on the web and found the solution.
- Open Microsoft Excel
- Go to File > Options
- Click on the Trust Center at the bottom of left panel
- Click on “Trust Center Settings” button on displayed pane
- Choose “Protected View” from left panel
- Uncheck all options on displayed pane, and click “OK” till back
Now when you open that file again, you will be able to do that, until any further issue, will keep that handy.