We always upgrade any software with the expectation of improvements, and most of the times we accomplish this mission successfully. Generally, the upgrade to new version of any application results in the improvement of its features, or its compatibility, or support. Therefore, it may cause serious disappointment when we move to the latest version of Microsoft Excel, i.e. Excel 2010 and we find that files created in its earlier versions like in Excel 2003 have become inaccessible. This is a common problem occurs with Microsoft Office users especially with the users of MS Excel.
Users use MS Excel for storing, organizing, and manipulating data. The program is included in MS Office suite and provides various basic and complex arithmetic operations for managing data in a tabular format. With time Microsoft launches new versions of Microsoft Office suites with improved functionalities in its various applications including MS Excel. To gain the benefits of these functionalities users upgrade to new releases of MS Office, but at times it is seen that these new releases cause inaccessibility of all the files that are created in the earlier versions. Let us see it with an example.
Suppose you upgrade your MS Office from 2007 to 2010, but when you try to open an Excel sheet created in 2007 in this new launched Office version, you encounter the following error message:
“The file is corrupt and cannot be opened”
This error message causes complete inaccessibility of all the data stored in the Excel sheet created in MS Excel 2007, thus it is really a troublesome issue. However, to open or access this file in MS Excel 2010, you can try below mentioned steps:
- Open or start MS Excel 2010.
- Go to ‘File >> Options’.
- Click ‘Trust Center >> Trust center settings’.
- Select ‘Protected’ view.
- Uncheck all the options that are available under ‘Protected View’ and click ‘OK’.
- Now restart MS Excel 2010 and open the Excel sheet.
Most of the times following these steps solves the compatibility issues of MS Excel. However, if in case you are unable to open your Excel sheet even after following these steps, then the chances of corruption of Excel sheet are high.
At times corruption of MS Excel sheet too renders this error message and results in the compatibility issues of Excel. If this is the problem with you, then you may try the ‘Open and Repair’ utility of Excel 2010 to repair the corruption. Follow below steps to use this utility of MS Excel:
- Start MS Excel 2010, go to ‘File >> Open’.
- Select the corrupt file and click the arrow provided next to the ‘Open’ button.
- Choose ‘Open and Repair’ and select a method to recover your Excel sheet.
However, if this method too is unable to solve your problem, then use of a professional excel file repair software is recommended. Professional Excel repair software repairs corrupt Excel sheet without altering its various objects. Therefore, using reliable Excel repair software is better solution when none of the resolutions work.
Author of this article is associated with Stellar Information Systems Ltd. Stellar Information Systems Ltd. is a leading data recovery company since 1993. If you have any question regarding excel file corruption & recovery and need technical assistance then you can connect with Stellar Information Systems ltd. at their Toll Free No +1-877-778-6087.