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.
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!
Works!!!! thanks man!
its working, Thank a lot.
Have seen this error recently… but with a twist..
File opens fine on Windows 7 Machines and Office 2010 (Excel)
However file will not open and shows corrupt on XP machines running Office 2010 (Excel)
Looking like more of a DCOM issue found here: http://goo.gl/RzqDS
Will be testing shortly to verify
That or apparently 2010 SP1 – But thought these machines had that on them Possibly not..
Currently fixed for Excel using the DCOM but Word files still show a different corrupt message
For that the only fix thus far is unchecking the top three items leaving the Enable Data Execution Prevention Checked had no effect so left it checked.
Not working
Thanks a lot…….Now I can use MS EXCEL
It worked for me. Thanks a lot.
Brilliant it works……. I was trying to fix this issue since 3 weeks and today it got fixed after following this steps i am really happy to say that its fixed…. Thanks A LOT
Thanks a lot
U r such a Genius man……….wow!
thanks alot its working …
Hey ,
Thnx friends.. really it solved my problem in excel as well as of power point where i was getting message like ” Your hard drive or floppy drive has a corrupt section (damaged track or sector).
A temporary operating system or network failure has occurred.” etc..
Thnx once again..
really great, thanks!
it is working. Thank you so much
Thank you, its sorted.
Super thanks man, its works.
I’ve been pulling my hair out because I couldn’t get xls docs to open when downloaded from my local swimming club, on my new computer. Error message “Docs were corrupt and could not be opened”
I have tried various downloads to install excel viewers. I tried uninstalling Office and re-installing it but that didn’t work.
Delighted when i got a result by following the above procedure.
Thank you very much. I was on the verge of taking the computer back to the shop.
Not working for me either.
Works!! Thank you..
Thanks a lot its working
Thank you dear, it really works.
Thanks a lot..
working… thanks
Many thank !!!!!!!!
It working
Thx
ITS WORKING NOW, THANKS .
Thanks it works perfect
It is working thanks
Thank you so much.. it worked..!
Thx dude….its working..
ok. thanks sir
Worked for me too!!!
U Solve My Problem
Thanks dear
Thanks – It works.
Worked for me.
Thanks for sharing
workinggggggggggg Greattttttt….solved the matter in mins…. for which my IT Admin took hours and failed to solve..
Thanks……
It works..Thank you
Well done guys, been driving me mad for weeks!!
Regards,
Keith
Working … Thanx !!
Problem fixed now working, Thanks a lot
thank you very much dear===Its working Many more thanks 4 the helping
Legend mate.. absolutely legend.
It works again thanks alot.
Its working Thank a lot..:-)
I have looked all week for a solution to my problem….this one worked! Can’t thank you enough!!!!
Thanks!!!!!!!!!!!! It works !!!!!!!!!
Its working very good, tnks a lot
Works a treat
Problem solved!Thanks dude!!!!
Thank you man…
Its work.
thanx a lot
Now it is working thank you
Thanks so much …………
Works!! Thanks a million!!
Great Thank you!!!
Its working… Thanks !
Regards – SK
Thank you so much!!!
Works for me
Thanks Sir
thanks. it worked
Great!!! its working !!
Thanks man
yes sir its working
working thank you
works great! thanks for the help
approved! this is working
This worked! Thank you!
Excellent…Thankyou very much..
thank’s boss
It works!!!! thank a lot ppl
Its works but is there any permanent fix?
works thanks
thanks a lot , is working file
It works.
Thank you so much for your valued advise. It help me .
Worked for me
Thx !
someone that coudln’t open excel files he receive from extenral domain in his outlook, I tried to delete outlook temp ==> same problem.
tried your advise, unchecked it all, works fine !
thank you very much!
Thanks a lot..
It’s working….
Tks.
THANX DEAR
It worked perfectly thank you very much.
Thank you very much! It worked!!
well you just fixed a problem that suddenly popped up two days ago – and, of course, just when I most needed the file – utterly ridiculous this should suddenly be a problem but there you go. It worked in under a minute. Wish I had the 180 minutes back that I spent reconstructing a file that existed…
works man,
thanks a lot
rgds
chetan
its working , Thank u very much
Thanks a lot. It worked for me.
Ohh it works,
Thanks buddy.
Thanks for valuable post
Worked! Thanks bro
yeap! it worked here too!
EXCELLENT! Great tip!
Awesome! THANK YOU SOOOOOO MUCH! It worked so easily.
Thanks a lot….this really works for me..
I have spent and entire month using a flash drive to save my excel files, as I thought my microsoft outlook was corrupting them when it gave me the error message ‘The file is corrupt’. You just saved me from a heart-attack due to frustration. Thanks a million times. Wish my I.T guy could have just told me this.
Finally!! Thanks a million for posting this – Microsoft is the worst user experience ever!!
Thank u for ur valuble information.it’s working nice.
Awesome! Thanks
not workn
Problem wasn’t solved unless unchecking all options related to older version of excel’s in File Block Settings.
thanx
you are a GOD… Thanks
VERY THANK.
verrrrrrrrrrrrrrrrrry thanks
Thank you so much! Microsoft was useless but your fix worked!
Thanks a lot. The solution works
Thanks Dear ! its working fine..
Awesome. Thank you!
THank u so much .. its helped me lot ..
Sathish.K
Waaoooo!!!! its working now…
thk…
Spot on!
MANTAPPPPPPPP
thank u so so so so much sir, u r gr8
Thanku
wow…. it worked!!…….thank u so much
Thank you! it works for me, I was bored by this for several days, really a good tips.
thanks a lot its working fine.but when i enable the options again i am not able to open the attachments of mails what i have sent .Can you please give me permanent solution
Thanks…it worked
it really works..
Graet it’s working
Thank you so much…
Its working super…
thank u thank u thank u so much
its working
Thank You very much, I had been moving docs to a different PC to Open the Excel docs. You have helped me from botheration
Thank you that worked.
Thank you. I have same “bug” in my PowerPoint. Now all “set up” is unsecured, and work fine!
Works great now! Thanks!!! Thought the issues was within Outlook, but it was Excel having the issues.
thanks alot..it helped
thnks alot..really worked…
Vow!!!Brilliant ….was trying from a very long time…n i got much appreciations from my boss after fixing this problem, thx Mr.Alexander
thank you
Awesome, thanks so much, this was driving me crazy.
a big THANK YOU, i tried so many other suggestions, non worked, yours worked first time.
Thanks so much
Thank you so very very much!!
Thank you, Works great now!
Thanks a lot… It works!!!
Thank you! This saved me from wasting time…
it help, thanks alot. abit late to find this resolution. at least no more problem.
Thank you so much… Its working fine
Thank you so much! it worked
Thank you! You helped me out alot!
THANK YOU
Thank you so much…………
Thank you. is works!
Thank you so much, it works!!!!!
WONDERFULL It works!! Thanks
Hailliluahhhhh!!! No thanks to microsoft troubleshoots