Sunday, April 16, 2017

Excel 2010 says "This file is corrupt and can't be opened"

excel 2010 error.png
Excel 2010 says...

Really? Even though this same file opens fine on another computer? Let’s see about that…

Google says...

excel file corruption.png
Aha! So let’s follow the instructions.

  1. Go to File > Options
  2. Head over to Trust Center > Trust Center settings
  3. Under Protected View, we turn off all the Protected View options
  4. OK and restart Excel.

excel trust center settings.png

And now we know for sure if the spreadsheet is “corrupted”. It’s not.

Life would probably be simpler with LibreOffice...