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"
This did the trick
Thank you
you are the best i have a client at work who have issue and i was able to help them thanks
Thnanx lot this solution
If you are getting error message "The file is corrupt and cannot be opened" in Excel 2010 while trying to open any of your saved excel document then you can fix this issue by using MS Excel Repair tool. It is especially designed to resolve the error that occurs while using the excel file.
I saved my files in my flash drive, unfortunately my flash drive has been corrupted. I am trying to open my recent excel files, but it says could not be found, check the spelling of the file name and verify that the file location is correct. Is there any possible way where I can save and open my recent documents.
I saved my files in my flash drive, unfortunately my flash drive has been corrupted. I am trying to open my recent excel files, but it says could not be found, check the spelling of the file name and verify that the file location is correct. Is there any possible way where I can save and open my recent documents. I tried to recover my files from my flash drive but 0 files detected
You are a genius!! Been searching the answers for years and bingo you are good!
THANK YOU SO MUCH!!! It worked for me!!!!
Thanks so much! I was having trouble with an Excel file after upgrading to Windows 10 (file had been opening fine before the upgrade) and this fixed it.
Thanks a million!
Thanks bro!! I was almost breaking this PC!
thank you!!
this worked! Thanks very much!
No protected view in my excel option.
How to solve?
Worked for Excel 2016.
Thanks
Thanks man, I appreciate it.
Its work for me when I uncheck all open in file block settings under trust center.
Thanks a lot...
my excel is working now
Thanks a man really it worked
My Excel File Is Currept I Requst for you Repair file
Hi,
I have a file that has the same message when opened in excel 2007 "The file is corrupt and can not be opened". But I still open it in excel 2010.
Please help!
Thanks.Its working fine
Worked like a charm...Thanks a ton...!!!!
Thanks!
Thanks man u r such a genius... was facing problem.long time finally it works ...thnk u so much
"Thank u so much for this info.my issue is resolved."
Hi sir,my excel file delete after that i use one recovery software fianlly find that excel sheet.when i open that excel sheet the file format and extension of don't match excel. the file could be corrupted or unsafe.please hlp me how to fix
excel sheet not open showing this error
"excel file not open because file format or file extension is not valid verify that file has not been corrupted and file extension match the format of file"
yeah .. on me too :(
Thanks a lot for your solution
Thanks a Lot, Now its working.
Yay! Thanks!
Its working Thanks lot
It fixed but setting does not retain after system restart.
nice man
THANKS!! YOU SAVE ME!!!!
THANKS!! YOU SAVE ME!!!!
"excel file not open because file format or file extension is not valid verify that file has not been corrupted and file extension match the format of file"
YAY!!!! Thank you so much!!
Thanks...Much appreciated!
Great it worked for me
Thanks
Hello,
I have tried this settings and also tried the dcomcnfg settings but still the problem is not resolve.I have also repair the MS office 2010 but no use.Still the files are showing the same error.
This file is working on normal PC but showing error in thin client which is connected to windows server2008r2
ok. thanks sir
Yesterday I had a password protected spreadsheet open for a couple hours. I saved and closed the file, then about 3 hours later I went to open it and it said the file was corrupted and couldn't be opened. Also the date of the file was from the previous day not yesterday. I have tried all the online solutions I can find as well as yours and they do not work. At work I use Excel-2010 and at home I use Excel-2016 This is a very important file to me, Can you help?
Thanks!
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
Only one file i see this msg other files are ok
Thanks a lot
Hello,
I had excel sheet (no backup) which i opened after 10 days, now it shows .xls: file format is not found. I tried using repair and open option and unfortunately not working.
Kindly help
Woo Hooo...
You sir, Deserves a Cookie!!!
great..issue resolved
Superrrrrrrrrr.... nice
Thank you so much
thanks a ton buddy
Perfetc :D
Working now...Thanks
still cant :(
not working ,give option for 2007 version where there is option of macro settig
not working please give alternate option for 2007 version as we have option of macro setting not protected view
Someone pls reply if u know the route cause i lost my most imp excel and i dont have any copy of it.
Thanks to Mr.Rajesh Peshiya who helped to recover all data from that file. Thank you so much i got back files which corrupted.
Thanks in tons
thanks a lot it is working !
Thanks Machan it's working fine....
From Sri Lanka.
You save our time !!! Ella Kollak.
Thank you very much, Machan it's working fine....
Best wishes from Sweden.
You save our time !!! Simon.
Hi good afternoon, can someone help me to restore my excel file. It became 0 byte and cannot be opened, Thank you in advance.
Still happening
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!
Fantastic, thanks a lot for sharing this
thank you so much you save my life !!!!!!!!!!!!
So thnks
its really working..lots of tnx
awesome. works. thanks
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
Thanks it worked.
Worked as a charm! 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
clear, thanks
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
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 !
Awesome. Thank you.
Fantastic! it works. U save my day. Thank you.
Thanks Team, really helped!!
Thank you.its good
excle file corrupted
Thank U so much
That was so helpful
Thank you!
This method works but it can be dangerous for document. if you another way to solve this issue then please suggest me. I searched on internet but not got good idea.
Thanks!
thank you
It works. Thanks for the help
/W
excellent solution !!! thanks !!!
It was awesome. Thanks
Thanks a lot for the solution.
I love you
u r d bst
Thank U so much
That was so helpful
That works perfectly!
Thanks so much!
Mate you saved me hours of work, I thanks you soooooo much...
This is temporary solution for some excels, but even in many excel this trick is not working getting same error
Had the same error and solution was similar but not the same.
At step 4 I instead had to go to Trusted Locations and check "Allow trusted locations on my network." I then had to click "Add new location" and add the location of the supposedly corrupt file to the trusted locations list.
Posting my solution here in case it helps anyone else.
Thank you for solution it work perfectly!
Thank you so much! That worked. That had been a major hassle for a long time.