In this article, you will learn how to access a corrupted file .xls in Excel 2010.
Usually, when you upgrade a file, you expect solid improvements. This can be a major disappointment when you upgrade to Excel 2010 and you can no longer access files in the Excel XNUMX format. .xls, created in Excel 2003 or earlier. You know what I’m talking about if you’ve ever encountered the following error message in Excel 2010: The file is corrupt and cannot be opened (The file is corrupted and cannot be opened). Do you still believe you can open this file? Of course you can!
Try the following steps to see your precious data again in the format .xls open in MS Excel:
- Run the application.
- Go to: Fillet > Options (File > Options).
- Open the section Trust Center (Trust Center) and click Trust center settings (Trust Center Settings).
- Выберите Protected view (Protected View).
- Clear all checkboxes in the section Protected View (Protected View) and press to confirm. OK.
- Restart Excel and try to open corrupted Excel documents now.
For security reasons, you should save your documents in the new MS Excel format, for example, . Xlsx. Follow the next steps: Fillet > Options > Trust Center > Trust Center settings > Protected View (File > Options > Trust Center > Trust Center Options > Protected View). Check the boxes for all suggested options, click OK and restart Excel.
This will restore all security settings to their previous state. I’m sure you don’t want to open any file unless you’re sure you’re safe!
That’s all. I hope this technique will be useful for you and your documents!