The file is corrupt and cannot be opened

Security is essential. The more sophisticated now days’ attacks the more poking around is needed preventing risks. Microsoft’s secure by design and secure by default paradigm comes however of some additional costs. The remediation expenses are sometimes higher than needed, due to completely misleading warnings or error messages.

Let say you publish an Excel workbook into SharePoint 2010 Excel Services and next you will try to open in Excel client that very same workbook clicking on  “Open in Excel” (Picture 1). The next moment you could be confronted with a puzzling error message stating “The file is corrupt and cannot be opened” (Picture 2). It is truly funny afterwards to see the “Was this information helpful?” link as well. Unfortunately the answer is thanks, not at all. As you can assume, the remedy is security related and could be done very easily.

image

Picture 1

image

Picture 2

In order to relax the by default set security settings, open Excel and in the backstage view click Options >> Trust Center >> Trust Center Settings… >> Protected View (Picture 3) and uncheck the Check boxes, click OK, OK. Close Excel and try opening your Excel Workbook again (Picture 1). This time the attempt will succeed.

image

Picture 3

Advertisements
This entry was posted in SharePoint 2010. Bookmark the permalink.

2 Responses to The file is corrupt and cannot be opened

  1. Daniel says:

    Thanks, you helped me a lot. I was experiencing this very same issue and solved it thanks to your post. Thanks a million.

  2. Chrissy says:

    It worked thanks a lot!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s