Ah, the file is corrupted. Or is it? maybe, maybe not. Here are a few solutions that you can use to help remedy this issue. These could occur in just about any program in the Office suite. It should be noted that this error can occur for numerous reasons and not all of them mean that the file is even corrupted (misleading error messages).
Office 2010 Only
- Click on “File”.
- Click “Options”.
- Click on “Trust Center”.
- Click “Trust center settings”.
- Click “Protected view”.
- Uncheck all the options under “Protected View”.
- Select “OK”.
- Restart Excel.
You can have the Office product try to repair the file if it is indeed corrupt.
- Select the “Open” option from the “File” menu (Office 2003, XP, 2000), the “Office Button” (Office 2007) or the “File” tab (Office 2010).
When the Open dialog appears, the right hand side of the “Open” button should have a down arrow, click the down arrow and choose “Open and Repair…”
- Click “Start”
Click “Control Panel”
Click “Uninstall a program” under “Programs and Features”.
Select “Microsoft Office”.
Click “Change”, and then wait while the change and repair is carried out.
Exit after the process is completed.