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!
![The file is corrupt and cannot be opened in Excel 2010 The file is corrupt and cannot be opened in Excel 2010](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uTPiA-vhBnNlvsTaTfMrpM3Nr14t-zVij5o-x1yY7jixZH475Rp99Y84SWmiPLHTKrI2ZezQay5MzjwBv6kyK_DKxtqwdk6lL4T19YQJFAfZaGT8Y4asI_4UfTjKyK3Cl0xVk-L9uplCzxSJLaPCRd0OAwaBd34J1wBZAqWrDdGmk6RrfPr_rhBiF05s07chjqHg=s0-d)
That’s it. Hope it will work for you and your documents
.
Thanks and see you!
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.Check all the options again under Protected View, click OK and restart Excel.
That’s it. Hope it will work for you and your documents
Thanks and see you!
This error message [The file is corrupt and cannot be opened] occurs when excel file get corrupted. In case the above steps get failed to repair corrupt file then you should use third party excel repair software. Stellar Phoenix Excel Repair is the most recommended software.
ReplyDeleteNiice post thanks for sharing
ReplyDelete