Recover data from damaged MS excel file

by Rohit Khurana on May 24, 2008


Some times Microsoft office excel files get damaged. MS Excel stops responding while opening damaged excel files.

But don’t lose hope as you can try some methods given below to recover your data from your excel.




Method 1:


Open the recovered copy of the excel file.


1. Open Start >> All programs >> Microsoft Office >> Microsoft Office Tools and click “Microsoft Office Application Recovery”

2. In application list click Microsoft Excel , click recover application.

Note: Don’t click End Application, otherwise recent changes to your workbook will be lost.

3. Open Microsoft Excel , the excel workbook you want to recover will be listed Document Recovery task pane.

4. To open or save your workbook, click the arrow on the right of the workbook in the task pane.


Method 2:


Use “Open and Repair” command


1. Start Microsoft Excel.

2. On the File menu, click Open.

3. In the Open dialog box, select the damaged excel file, Click the arrow on the Open button, and then click Open and Repair. Click the image below to enlarge.

open and repair file in MS excel


4. When prompted click Repair to try to recover your most recent changes.

5. If you receive the following error message, click Yes.

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

6. Save your recovered workbook, that’s it done!


Method 3:


Save the file in HTML format


This method is useful when you are not able to save the files as .xls file, see the steps below:

1. In Microsoft Excel the File menu, click Save as Web Page.

2. Under Save, click Entire Workbook, and then click Save.

3. Close the file and open the file again in Excel.

5. On the File menu, click Save As.

6. In the Save as type list, click Microsoft Excel Workbook.

7. Change the name of the file to create a new copy without replacing the original.


Method 4:


Through Recovery Toolbox tool


Last but not the least if none of the above methods works, you can try this software called RECOVERY TOOLBOX FOR EXCEL 1.1.5 which is free to try.

Some Features:

Recover style of table
– Recover number formats (except colors, used in a number format)
– Recover fonts
– Recover worksheets
– Recover columns width and rows height
– Recover cell data of workbook

and so on.


We hope at least one of the above methods will work for you.

If you like this article or this article helped you, you can +1 to recommend this article on google plus.

You can follow us on Twitter or join our Facebook Fan Page. If you have a question to ask us, submit your question at Answers By Trouble Fixers.

Looking for something else? Search here :

{ 2 comments… read them below or add one }

zlatan24 August 25, 2008 at 7:15 am

I heard about not bad application-how to recover Excel files, it supports almost all existing versions of XLS and XLSX formats: Microsoft Excel 97, 2000, XP, 2002, 2003 and 2007 (xlsx repair), it helps to recover practically all the significant information, Program can repair Excel files Microsoft Windows NT 4.0, Windows 2000, Windows XP, Windows XP SP2, Windows 2003, Windows Vista. Software can to do the xlsx repair of Microsoft Ofiice 2007.

Najeeb January 30, 2011 at 9:07 pm


Not Recovering mine

Leave a Comment

Previous post:

Next post:

© TroubleFixers – All about fixing computer troubles2007-2016 . All Rights Reserved.