by Quick tip: learn how to access a corrupt xls. file in Excel
Usually when upgrading you expect nothing but improvements. So it can be really disappointing when after moving to Excel 2010 you have no chance to access your .xls file created in the application version 2003 and earlier. You understand what I'm talking about if you ever encountered "The file is corrupt and cannot be opened" error in Excel 2010 and later. Still think you can't open it? Actually you can!
How to open a corrupt xls. file in Excel 2010 - 365
Try the following steps to see how your precious .xls data appear in Excel 2010 and later:
- Open Excel.
- Click on File -> Options.
- Select Trust Center and press the Trust center settings button.
- Pick Protected view.
- Uncheck all the options under Protected View and confirm by pressing OK.
- Restart Excel and try to open the broken Excel documents.
Note. For safety reasons, you should save your document with new Office format like .xlsx. You can do it this way: File > Options -> Trust Center -> Trust Center settings -> Protected View.
Check all the options again under Protected View, click OK and restart Excel.
This will set the security options back. Sure, you don't want to open any file unsafely.
That's it. Hope it will work for you and your documents :).
Thanks and see you!
390 comments
Fantastic! it works. U save my day. Thank you.
Awesome. Thank you.
Hello Team,
I'm facing the same issue after upgrading my office 2010 to 2016. .xls file is not opening and getting same error "the file is corrupted and cannot be opened" even .xlsx file working fine.
this suggested is very helpful to me. thanks team !
I have a similar problem, but nothing to do with an upgrade.
I have a macro enabled file open in XL2003, which originated as an xlxs file from XL2010. Conversion to an xls file was straightforward. I then in 2003 added the macros. It is now saved as an xlsm file, and when XL2003 saves it is reports that the file is being converted.
Until the latest changes to the macros, the file could be saved, closed and re-opened. Now the macros do all they should do, the file can be saved, but if I close it it cannot be opened. XL reports that the file is corrupt.
I can go, and have gone, back to an older version (v3) to make the changes again. Which I have saved now as v5. v4 cannot be opened by XL2003 on the original machine (the machine that saved the file). v4 and v5 cannot be opened on a different machine by XL2010.
I am reluctant to close v5 on the original machine until I know that I can open the saved version elsewhere.
Does anyone have any clue as to what may have happened? I am at a loss. I understand file corruption, and that a corruption may occur during the save operation, but do not expect it to hit what is really the same file (the v3 file saved as v4 and v5) in the same way on two different occasions, so I have discounted any file system or OS corruption.
It may be something introduced by the converter that XL2003 is using when saving the file, but I do not understand why the converter would add to the file something that XL2003 does not understand. But even if it did, I would then still expect a later version of XL (XL2010) to be able to read and open the file.
Thank you
Coco
clear, thanks
Hey
I am using Php to export the data from the database to excel sheet.
I am saving the file using .xls extension
$filename = "VMS_Report_" . date('Y-m-d') . ".xls";
After exporting the data when I try to open the file it shows the file is corrupted and unsafe
I am using Office365
I tried all the possibilities that are available sources on internet
Worked as a charm! Thanks!
Thanks it worked.
excel canot open the file beccause the file format or file extension is not vaild. verify that the file has not been corrupted and that the file extension matches the format of the file -how to recover the file
awesome. works. thanks
its really working..lots of tnx
So thnks
thank you so much you save my life !!!!!!!!!!!!
Fantastic, thanks a lot for sharing this
Odd. Two machines in our office, and only one had this problem. The Trust Center settings were identical for both in both Word 2010 and Excel 2010. But one of them would not open downloaded files at all, always saying they were corrupt. Your solution did work, but it doesn't make sense that it's a problem on one machine and not the other.
Anyway. Thanks!
Still happening
Hi good afternoon, can someone help me to restore my excel file. It became 0 byte and cannot be opened, Thank you in advance.
Thank you very much, Machan it's working fine....
Best wishes from Sweden.
You save our time !!! Simon.
Thanks Machan it's working fine....
From Sri Lanka.
You save our time !!! Ella Kollak.
thanks a lot it is working !