Friday, April 19, 2013

Excel: the file is corrupt and cannot be opened

I take 0 credit in this post, it is complete and utter rip from here:
http://www.ablebits.com/office-addins-blog/2011/11/30/excel-open-corrupt-files/
If you get this error:

The file is corrupt and cannot be opened in Excel 2010
  1. Open the application.
  2. Click on File -> Options.
  3. Select Trust Center and press the Trust center settings button.
    title=
  4. Pick Protected view.
  5. Uncheck all the options under Protected View and confirm by pressing OK.
  6. Restart Excel and try to open the broken Excel documents.

Back to my words.
This worked for me recently when a user couldn't open a document that everyone else could.  I tried opening and resaving the document, tried opening from different locations.  Different users saved it for her and sent it, nothing worked.  I found this gem at http://www.ablebits.com/office-addins-blog/2011/11/30/excel-open-corrupt-files/ and was able to resolve the issue.

Thanks again Ablebits!
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Pulling local admin accounts on a windows system WITH POWERSHELL

 There’s a couple ways to get them, I’m sure you’ve been around the internet looking. The Powershell scripts I use: Get-LocalGroupMember -Gr...

  • Vizio soundbar is blinking 2 dots
    Situation: Vizio sound bar works. But all of a sudden, no sound.  The movie is playing fine, but no sound. On the sound bar itself, two ind...
  • Dell 9020 3 displays
    I have a customer that would like 3 monitors, for whatever reason. The Dell 9020 is capable of this, and this is how I got it to work. No ...