Over the past 10 years I have had to recover many corrupt Excel files. Early on there were not that many programs that could recover an Excel file but that has since changed.
Free Excel recovery Method
The free method works some of the time. We are going to be using the built in repair tool offered by Office. Always make a copy of the file you wish to recover first so you do not make matters worse.
- On the File menu, click Open.
- In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
- Click Open and Repair, and then choose which method you want to use to recover your workbook
The above method may not work to recover and repair the excel file. However it’s worth a shot as it’s free and only takes a minute to do.
Another tip for you is you may have the Excel file you are looking to recover from a TEMP file location. If the file was opened in the past it may be located in the below sections
XP: C:\ Documents and Settings\<username>\Local Settings\Temp
Windows 7 / Vista: C:\Users\<username>\AppData\Local\Temp
The file will most likely be named different and will have a .tmp extension. It’s a pain to look through everything but it may be in there.
You may also want to consider opening Excel in Safe Mode. While this normally will not work it’s worth a shot as it’s worked for me in the past on a few occasions.
To open Excel in same mode you need to enter the path to the excel.exe program and place “/s” with out the quotes after the file path.
Excel Recovery Software
The Best Excel Recovery Software
Excel Regenerator get’s our vote for being the best Excel Recovery and repair software. This is by far the most advanced Excel recovery program. The makers of this program do not seem to do enough marketing of this program for whatever reason so many computer experts don’t even know about the options this program has.
It’s the only one I found that can ignore file systems and just scan the physical drive for all information pertaining to Excel files. Even if the drive has been deleted, formatted, has a corrupt partition and the like.
The down side to this type of advanced recovery method is the time it takes to scan the entire drive and it has a limited pre-view of the file until you run the recovery. If you have a 500 Gig hard drive the program will scan the entire contents of the drive in an attempt to locate all information per-taning to your Excel file. Most other programs just take the current corrupt Excel file and pull what data it can out of it and then it re-builds the file. Excel Regenerator goes well beyond this measure and attempts to locate everything related to the Excel file. This is great if you have overwritten an excel file and want to revert to a previous version that Office can not locate.
End users may find this program a little confusing but computer techs should feel right at home using this advanced Excel recovery program to recover corrupt Excel files.
If you want to plan ahead or your a computer technician you might as well look at purchasing the Office Regenerator package. This include Excel Regenerator, Word Regenerator and PowerPoint Regenerator.
The first program we should talk about is Stellar Excel Recovery. It’s a very easy to use program that allows you to recover corrupt Excel files. It works for Excel 2010, Excel 2007, Excel 2003, Excel 2000 and Excel XP.
In most cases if your Excel file is recoverable this is the program that can do it.
There are times when a file may not be recoverable due to a bad sector on your harddrive. This normally only happens when your harddrive is mechanically failing. If you are hearing knocking sounds on your drive you may want to run the hdd regenerator program first to repair the bad sectors then run the Stellar Excel recovery program.
They do offer a try before you by experience. This lets you know if your data can be recovered using this program before you make a purchase.
Easy Excel Recovery is a very good Excel recovery program. Easy Excel Recovery repairs corrupted Excel spreadsheets, recovering as much original data as possible. No matter how badly damaged the file is, Easy Excel Recovery will still work with the document and extract information that is still there.
Basically Easy Excel Recovery reads the spreadsheet and pulls all the information still available. It then extracts the information and repairs the original structure of the file.
The really nice thing about this Excel repair program is it can even scan your drive if it was formatted or inaccessible by Windows and locate your Excel files and make the repair. It’s a solid program and one I recommend using as well.
If you need to recover deleted files or files that have been formatted and your looking for a way to recover all your excel files and not repair just a single corrupt Excel file we recommend Recover My Files.