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.
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.
Download RECOVERY TOOLBOX FOR EXCEL 1.1.5
We hope at least one of the above methods will work for you.
Useful Related Articles
- User profile damaged warning- "The system has recovered form serious error"
- How to recover a modified email attachment file in Microsoft Outlook
- Windows does not start due to error message: " Invalid Boot.ini File"
- Restore your important data backup from backup-file
- Recover deleted files in recycle bin to different location
- Backup your important data in 9 easy steps
Most Popular Troubles and Fixes
- Not able to open drives on hard disk by double click
- How to remove Win32/NSAnti, d.com virus without any anti-virus tool
- Drive opens in new window on double click in windows XP
- Not able to show hidden files and folders
- How to remove Newfolder.exe virus
- How to protect your computer from virus in pen drives
- Task Manager disabled problem in windows xp
|
Get solutions to common computer problem's directly to your inbox for free |
1 User Commented In This Post
Subscribe To This Post Comment Rss Or TrackBack URL