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!
Merge data from 2 worksheets in five easy steps
Add Merge Tables Wizard add-in to your Excel and merge matching data in your worksheets in seconds:
- Use one or several columns as the unique identifier to match rows.
- Update existing columns in the main worksheet or add new from the Lookup table.
- Add non-matching rows to the end of the main table after all other data if needed.
- Use the add-in with any Excel version: 2013 64- and 32-bit, 2010, 2007 and 2003.
Special offer only for our blog readers and only until next Friday!
Click to get a license of Merge Tables Wizard and save 20% off the regular price!
- How to merge two Excel worksheets
- Compare 2 Excel sheets and remove duplicates
- Group data in an Excel PivotTable