Nov
30
Get rid of "The file is corrupt and cannot be opened" in Excel 2010
Quick tip: learn how to access a corrupt xls. file in Excel 2010
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. Still think you can't open it? Actually you can!
Try the following to see how your precious .xls data appear in MS Excel
- Open the application.
- 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.
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!
You may also be interested in
Excel formulas
CSV
Excel functions
Print
Financial functions
Vlookup
Merge data in Excel
SumIf
CountIf
Excel Compare
If statement
Excel Charts
Pivot Table
Conditional formatting
Excel formatting
Excel duplicates
Excel date
Excel tips
Excel macro
Outlook
Google Sheets
Outlook duplicates
Outlook templates
353 responses to "Get rid of "The file is corrupt and cannot be opened" in Excel 2010"
thanx it helped
Thank you very much. It worked perfectly.
didn't work on server 2012r2 office 2010
THANK YOU, so much! I had a spreadsheet logging 20 years' worth of irreplaceable data that suddenly gave me this error message - following your steps fixed it perfectly! THANK YOU!!!
Thank you! Was having this issue for a while. Resorted to opening files in Google Sheets then copying into Excel. Wasn't great. Your solution works a treat :)
This worked for me perfectly and save tons of my time and frustration. Thanks!
did not work ..
Thank you! This has been driving me nuts for the past week :)
Perfect, Thank you
Thanks so much worked just great this got me nuts for almost a year, also it always happen to me if the file was coming from Italy then it wont open now we all good to go thanks so much again .
Thanks for that insight it has worked well for me, thanks
Thank you very much it helped me too
Thank you so much for this tip. Saved me from agony.
Appreciated, it really works.
its working..thanks lot
Worked PERFECTLY! Thanks a million!!!
thank you!
Thank you so much!
Thanks... This helped me a lot
thank you so much! it is working now.
Thanks alot! I use excel alot and have a lot of docs which are needed to be downloaded every day. I was quite worried about this when it showed up but now thankfully the problem is resolved.
Cheers Buddy!
worked
THANKS A TON!!
THIS REALLY HELPED AND SORTED OUT THE STUPID ISSUE!
THANKS A LOT AGAIN!!!
MS EXCEL 2019 IS NOT OPEN. IT SHOWS OPEN IN SAFE MODE IN WINDOWS10
Thanks very much sir..
you just save my long distance job, by remote access...
Thank you, thank you, thank you!!!!!! You're a lifesaver...
This just worked for me too! Thanks so much!
That you so much!!!! it worked :)
Unfortunately, this solution is not working for me, I had already all these boxes unchecked and I still receive the message that my files are corrupted and this happens so often, that I always need to create several copies every time when I save an Excel file. I'm using Windows 10 and Office 365 the most recent version.
Thank You.
It worked, I had issue with amazon files. Thank you.
thank you so much! its worked:)
Thank you. it worked.
Thanks a lot. Work perfectly.
worked perfectly , thanks :)
Worked. Perfect
hai
i have issue with Excel office 2013 stander it show in desktop all files as a pdf but it is Excel
Other way, Excel Option >> Trust Center >> Macro Setting >> checked item Enable all macros( not refomented; potentially dangerous code can run)
Just Sign out from the account. The file shall open hopefully. Thanks.
Muchas gracias !!!! Pensaba reinstalar todo office!!!jajajajaja
it works. Thanks a lot