7. Once you have been able to open the document, save it with Office new format (i.e. xlsx)
8. Go to File > Options -> Trust Center -> Trust Center settings -> Protected View
9. Check all the options again under Protected View -> OK
10. Restart Excel 2010
The above will set the security options normal again. Although the process of setting back the security is a burden, it is necessary because if not, then you could forget (as in my case =) ) and could open any file without security...
This worked - but the dialog and action needs to be fixed ASAP - as it's happening with previous version WORD documents as well. The file is indeed NOT corrupt - and until I found this, I had previously gone
out to download the free 'Microsoft Viewer' program, installed it, and had to view with that and convert to PDF for a client.
Microsoft's software is better than this - and this major bug needs to be fixed ASAP before it hits most of mainstream by at LEAST giving us the option to open the file (a security warning perhaps) and NOT saying the file is corrupt. I've never seen something
quite this 'sloppy' in a final Office product in my 15+ years of using Microsoft Office.
This did not work for me either. Could it have something to do with the .xls file being created on a Mac? I know with Office 2007 I would get an error opening .xls and .xlsx files created by a Mac (Data may be lost...etc). Since upgrading to Office 2010
I cannot get those same files to open.
I run Windows Vista and Office 2010 Professional. This is ridiculous... $300 software suite...