How to Recover Corrupted Excel File 2010 & 2007

 

Microsoft Excel workbooks are great sources of data storage and management for the users in corporate as well as in schools, colleges/institutions, and individuals at their homes. In fact, alike other crucial components of Microsoft Office suite, Excel workbooks are preferred the most for both personal and professional uses across the globe. Along with that, they require immense care to store information securely. Otherwise, Excel corruption scenarios come into site along with their consequence, i.e. the loss of crucial data.

Corruption in Excel Workbooks

No matter which version of Microsoft Excel you are using, you are never far off from corruption and scenarios causing loss of crucial data. When you open an Excel file, it automatically starts recovery and puts the best efforts to repair the file. However, it cannot always fix the corruption or repair the file automatically. If it fails, you may try repairing it manually.

Microsoft Excel 2007

Since people have different versions of MS Excel, one cannot implement the same process to repair Excel files or fix corruption in the Excel files created on different versions of MS Excel. Thus, each version of Excel requires following different steps of the repair process. In order to recover Excel 2007 files, you need to go through the following steps:

Repair Excel 2007 Files Manually

  1. Open Microsoft Excel 2007 and click Office button, and then choose Open in the menu.
  2. Browse the corrupt Excel 2007 file on your computer and select it in the Open dialog.
  3. Click the arrow next to the Open button and choose Open and Repair.
  4. Click Repair when prompted to recover data to the maximum.
  5. If repair fails, click Extract Data to extract values and formulas from the corrupt file.

Recover Data from Corrupt Excel 2007 Files

If you are not successful in getting your Excel 2007 file repaired with the above steps, try the following steps to recover data from corrupt Excel 2007 file:

  1. Move the corrupt Excel file to any other computer and try opening in MS Excel 2007, as it resolves the errors related to disk and network.
  2. If you are able to open Excel file, you can still revert to its last saved version, in case the corruption occurred before you could save it again after modifying it.
  3. a. With Microsoft Excel 2007 opened, click Office button and select Open in the menu.

    b. Browse the corrupt Excel 2007 file and click Yes when prompted to revert to its last saved version.

Create Backup Copy Automatically

  1. Open Microsoft Excel 2007 and click Office button, and then click Save As in the menu.
  2. On the Save As dialog, click the arrow next to Tools button (given at the bottom left corner) and choose General Options.
  3. On the General Options dialog, check ‘Always create backup’ check box and click OK.

With this, you instructed MS Excel to create backup of every Excel file you create or open to work in.

Microsoft Excel 2010

Microsoft Excel 2010 is one of the eminent versions of Excel that gathered more number of users and satisfied their data storage and management needs. Even though Excel 2010 is amongst a few recent versions of Microsoft Excel, scenarios like corruption in the workbooks still come into sight. Alike earlier versions of Excel, you can repair and recover Excel 2010 files in the following manner:

Repair Excel 2010 Files Manually

  1. Open Microsoft Excel 2010 and click File, and then choose Open in the menu.
  2. Browse the corrupt Excel 2010 file on your computer and select it in the Open dialog.
  3. Click the arrow next to the Open button and choose Open and Repair.
  4. Click Repair when prompted to recover data to the maximum.
  5. If Excel fails to repair, click Extract Data to extract values and formulas in the corrupt file.
  6. a. Excel prompts to ‘Convert to Values’ or ‘Recover Formulas’.

    b. Click Yes if it prompts the following error:

    “The document file name caused a serious error the last time it was opened. Would you like to continue opening it?”

    c. When Excel opens the last saved file, save it.

Save Excel 2010 File in HTML Format

If you are able to open Excel 2010 file, choose the HTML format to save it in filtered form. After that, close the Excel file, as you have your data in HTML file. See how to save Excel file in HTML format:

  1. Open Microsoft Excel 2010 and click Save As, and then choose Web Page in the Save as type drop down list.
  2. "Enable Entire Workbook option, and then click the Save button.
  3. Close the Excel file and reopen Microsoft Excel 2010, and then browse that HTML file.
  4. Click File menu and select Save As in the list.
  5. Type-in a different name and choose Microsoft Excel Workbook in the Save as type drop down menu, and then click the Save button.

With this, you would be able to access the information that is safe and is independent of the corrupt Excel file.

If you fail to recover corrupt Excel 2007/2010 file, perform Excel file recovery with Stellar Phoenix Excel repair software.

Follow below steps to recover data from corrupt Excel 2007/2010 file using Stellar Phoenix Excel repair:

  1. Download & run the software on your windows-based machine. Click on the 'OK' button to proceed.

  2. If you know the location of corrupt excel 2007 or 2010 file, then click 'Select File' to select file. Otherwise, click 'Search file' to search the file.

  3. Click 'Scan' button to scan selected corrupt file.

  4. Scanning of corrupt file is in process. Scanning time is directly proportional to the size of corrupt Excel file.

  5. Now, see the preview of your corrupt excel file from left panel of the software.

  6. Click 'Repair' icon to recover excel 2007 & 2010 data.

Related Products
Stellar Phoenix Word Repair

Stellar Phoenix Word Repair

Read more >>

Stellar Phoenix PowerPoint Repair

Stellar Phoenix PowerPoint Repair

Read more >>

Stellar Phoenix & Stellar Data Recovery are Registered Trademarks of Stellar Information Technology Pvt. Ltd.
© Copyright 2017 Stellar Information Technology Pvt. Ltd. All Trademarks Acknowledged.