We're upgrading to Office 2010 and having some fun issues with old and new .xls files.
Current issue is that many .xls files (as opposed to the new .xlsx files) we get an error when trying to open them. The error states "File is corrupt and cannot be opened". [see attached screenshot]. For the sake of testing, we can create a new file and save as a .xls and get the same error.
I have followed instructions to go into Excel's trust center and unchecked all items in protected view, with no success.
Currently I'm getting this on two computers. As a workaround, these users have been emailing these "corrupt" files to me and I convert them to an .xlsx file and they work fine.
Both computers with the issue are newer Dell's (different models) running Win7 Pro (x86), Office Standard 2010
Excel 2010 - "file is corrupt and cannot be opened"
In case you can't handle your issue via the guide on above, then your excel file is severely corrupted and you may offer following sources below, last one was created only for complicated cases
The first thing to try is to open it with the Repair option in Excel. You can do this by clicking on File and then Open. In the Open dialog box, single click on the Excel file and then click on the small arrow next to the Open button.
Go ahead and click on Open and Repair and you’ll get a message asking if you want to repair, which will recover as much data as possible or if you simply want to extract data, which will copy out the formulas and values.
You can try to repair first and see if it can recover the whole file, if not, you can then try to extract the data.