Know How to Recover Corrupt Excel File (.xls) Without Losing Any Data - Digital Hints

Monday, December 18, 2017

Know How to Recover Corrupt Excel File (.xls) Without Losing Any Data

5 Best Ways to Recover Corrupt Excel File – Repair XLS Spreadsheet Easily

Sometimes corruption error appears whenever users try to open the Excel or Word file. Due to this data damage, or crash users are not able to read the document. This is a challenging task for many users, therefore, not an easy one to execute. Nevertheless, it will not become very difficult from now onwards as in the upcoming section of this blog; we will explain the best five ways to recover corrupt Excel file in an efficient manner.

Manual Tricks to Recover Corrupted Excel File

Go through the following measures that will help to repair damaged .xls file. Follow any one of the techniques:

1. Open and Repair Method

  1. Firstly, open the blank Excel workbook.
  2. Now, click on the Open option.
  3. Search for the desired file >> Select Open and Repair option. This option is available in a drop-down list associated with the Open button. Meanwhile, Excel cannot open the file then, choose Extract Data.
  4. If the Excel caused a serious error the last time it was opened, you must agree to continue opening it.

2. HTML Solution to Recover Corrupt Excel File

  1. Open the .xls file.
  2. Then, go to Save As option. If necessary, select Other file Formats from the list of options.
  3. Now, select the Web Page from possible file extensions or types.
  4. Keep in mind that Entire Workbooks will get selected and press Save option.
    Note: Some elements of the formatting may get lost. Click Yes button to confirm or Help for more details..
  5. Locate a saved document file.
  6. Right-click on the File >> Choose the option Open With >> Select Microsoft Office Excel.
  7. Choose Save As option and selecting the Excel format from a drop-down list. For instance, Microsoft Excel 97-2003 provides the classic .xls format, whereas Excel Workbook provides the .xlsx format.
  8. Now, you can change the title to prevent this by any kind of confusion/saved over the original (corrupted) file.
  9. In the last, click on Save button.
The above two solutions to recover corrupt Excel file are found to be the best among the other solutions.

3. Copy Data Method

  1. Open an Excel file.
  2. Now, right-click on the sheet and choose an option Select All Sheets.
  3. Right-click the sheet tab >> Select Move or Copy option.
  4. Afterwards, choose the New Book and enable the Create a Copy checkbox.
  5. Click OK button.

4. XML Method to Repair Damaged Excel Spreadsheet

It works for MS Excel 2003 editions:
  1. Open an .xls file.
  2. Go to Save As option.
  3. Choose XML Spreadsheet from the given list of all possible formats and press Save button.
  4. Exit the file and then, reopen it in Excel file.
  5. Click Save As option.
  6. From the drop-down list, choose the Excel format (ex. Microsoft Excel 97-2003 or Excel Workbook).
  7. Change that title to prevent saving over an (crashed) original file.
  8. Click on the Save button.

5. Other Possible Ways One Can Try to Recover Corrupt Excel File

  • Close Microsoft Excel, re-open it and then, try to open that file again.
  • If this does not work, restart the PC, open up Excel files and try to open it again.
  • If the above point does not work, remove the contents of your c:\windows\temp directory and then, reboot the computer.
  • If this does not work, open a file with OpenOffice. This is free software that may also be able to work around data corruption or damage.
  • If it does not work out, open Excel spreadsheet in Safe Mode. This can disable VBA code and Add-ins.
    • Restart the computer system in Safe Mode.
    • Click on Start menu >> Run. Now, enter the correct path to an executable file. Depending on Windows version, this might be C:\Program Files\Microsoft Office\Office\excel.exe, C:\Program Files (x86)\Microsoft Office\Office11\excel.exe, or have similar. (For Excel 2002, Office XP, click cancel if the MS Office Installer starts; MS Excel in safe mode will yet start)].
    • Try to open that file.
  • If this does not work to repair & recover corrupt Excel file, make sure to scan any file for viruses. Keep in mind that macro heuristics scanning option is turned on. So, you can ask your IT administrator how to perform this.
  • If you do not get a virus, copy a file and rename that copy with the .doc extension. (This option is not available on the latest systems)
  • If it does not work, try to analyze if the desired file is unrecoverable on a disk. Open that file in Windows Explorer and try to copy or move it to some other location.
    • If you want to copy a file to another location, then, skip next step. If not now, then the actual sectors on a disk might be corrupted.
    • If the data is being valuable to you, seek all professional services as the damaged hard disk data recovery is just not for faint involving the heart.
  • If it gets fail, try to open a file in the latest version of MS Excel. With increasing the numbers of an edition, their capability to repair and restore crashed file also rises. If this does not work or such version of MS Excel is not available, you have to check another spreadsheet application and try to open that file in the program.
  • If it does not work to recover corrupt Excel file, copy a file and rename that copy with the .txt file extension. (This option is not available in recent systems.) Try to open the file, and if Windows shows it cannot open any Notepad but can open it in WordPad file. Be certain to turn on word wrap in either program or Notepad from the Format menu, and in WordPad it is under the View (Select Options >> Text Tab >> Wrap to Window). Further, look for where the data get stopped, which must be followed by various space characters. These really tell Excel spreadsheet where cells, columns, and rows are available. When you search for the last bit of data, remove rest of a file. After this, renaming it back to the .xls extension, now try to open the particular file in an older version of spreadsheet you can obtain. You can be able to restore numerous spreadsheets containing similar data.

A Perfect & Smarter Way to Repair & Recover Corrupt Excel File

If above-stated approaches get fail, users can take help of a reliable third party tool for this task. Excel Recovery tool is one solution to repair and restore damaged Excel .xls file without installing MS Office suite. Moreover, users can easily understand and know how to repair crashed Excel file of any size without file size limitation. It has easy-to-use interface even a novice user can use it without taking an expert help.

Final Words

As everyone knows that corruption is one of the major reason while opening the Excel file. Therefore, in the above section, we have discussed five different ways to recover corrupt Excel file. All such solutions keeping the data safe and secure in a convenient manner. Users can use any approach resolve corruption issues. Also, we have explained each solution along with its complete step to execute it. Else, users can use third party tool i.e., Excel recovery that helps to repair damaged .xls or .xlsx file in an efficient way.
Disqus comments