Previous Article

How to Repair Access Data

Next Article

How to Repair Data on a Hard Drive

How to Repair Data in a Corrupt Excel File

Repairing data in a corrupt Excel file can be time-consuming and unsuccessful. Hopefully you have made regular backups of your files, but if you haven't be prepared to invest some time and possibly some money in trying to restore your corrupt Excel file.

1.) Restore the corrupted Excel file from your backup. Locate the file in question on your backup drive or backup disk and copy/paste it on top of the corrupt file. This will replace the corrupted file with an older version of the file that was saved prior to any corruption happening. Open the restored file to confirm it is, in fact, restored and in good condition. 


2.) Change the file extension on the corrupted file to something other than .xls to try and force it open in another program. Use .doc to try and open it in Word; use .txt to try and open it in Wordpad or Textedit; use .html to try and open it in your internet browser. If any of these are successful, immediately copy and paste the text into a new Excel file and save. You will have lost formatting, but you will at least have the text to work with.


3.) Transfer the corrupted file to a CD or email it to yourself so that you can move to another computer and try opening it. It could be that the file itself isn't corrupted, rather something is wrong with Excel. If this works, immediately copy and paste the text into a new Excel file and save your work. With corruption, you never want to take any chances and it is always best to copy/paste the text into a new file, which is essentially like starting over.


4.) Call a data retrieval company. When all else fails and you really need that data back, enlisting the help of professionals may be the way to go. Expect to pay quite a bit for their services, but in the end having your data back is probably well worth their fee.


5.) Backup your work going forward. Sometimes lessons are learned the hard way, but always have a backup in case the worse happens and you will save yourself both time and money.