Wednesday, October 13, 2010

How to Recover a Corrupt Excel File

An Excel workbook is prone to corruption, just like other MS Office files. Corruption can occur in an Excel file due to many reasons including application errors, failed network connections, unexpected computer shutdown etc. To battle the corruption problem, users strongly believe in maintaining backups. Backup copies, however, won't always contain the updated information, and you have to re-enter the data and required content. In order to avoid such nagging problems, it is better to consider repairing an affected Excel workbook. Microsoft provides various methods to help you perform Excel repair on your own .See the tips section for them. You may want to try them first, or a combination with the list below.

Step:

1. Close down Excel, re-open it and try to open the file again.

2. If this doesn't work, restart the computer, open up Excel and try to open the file again

3. If this doesn't work, delete the contents of your c:\windows\temp directory then reboot. Try again.

4. If this doesn't work, restart the computer, open up Excel and try to open the file again
  • Click on Start then Run then enter (including the quotes and the /s extension): "C:\Program Files\Microsoft Office\Office\excel.exe" /s ("C:\Program Files\Microsoft Office\Office10\excel.exe" /s (for Excel 2002, Office XP, click cancel if the MS Office Installer starts, Excel in safe mode will still start)
  • Try to open the file.
5. If this doesn't work, be sure to scan the file for viruses. Make sure your macro heuristics scanning option is turned on. Ask your IT administrator how to do this.

6. If you don't find a virus, find the file in Explorer, right click on it and rename it, replacing the .xls extension with the .doc extension. Try to open it as Word document.

7. If this doesn't work, try to determine if the file is unrecoverable on the disk. Open the file in Explorer and try to copy it to another location.
  • If you can copy the file to another location, If not, then the actual sectors on the disk may be corrupted
  • If the data is valuable enough to you, seek professional services as a damaged hard disk file recovery is not for the faint at heart.
8. Try to open any damaged disk recovered file immediately, miracles do happen.

9. If the recovered file won't open or you could copy the file to another location, try to open the file in a more recent version of Excel. As the version numbers increase, their ability to recover corrupt files increases. If this doesn't work or such a version of Excel is not available, see if some other spreadsheet application is and try to open the file in that program.

If the above-suggested methods do not help you in repairing a corrupt Excel workbook, then you should not lose hope. Using one of the professional Excel repair tools, you can repair a damaged workbook without putting in too much efforts . you should download Stellar Phoenix Excel Recovery without any qualms. The application repairs corrupt workbooks, created with MS Excel 2007, 2003, 2002 and 2000 versions. Incorporating simple GUI, this repair Excel file utility scores much higher than other recovery applications in terms of performance and user-friendliness.

4 comments:

  1. A perfect and informative blog about Recover excel file comprising various methods to recover a corrupt Excel file. One should try these methods but even after trying these methods or if you need fast, reliable, and stable Excel File Recovery then try Excel Repair and Recovery software.

    ReplyDelete
  2. Intersting and beautiful blog lovely presentation thanks for sharing your views...Excel Support We24support tech team are available 24/7 for repairs on computers, printers, microsoft excel 2010laptops, desktops. Our tech team taken to new heights with our technician’s knowledge and support.at 1-866-978-0799 microsoft excel support

    ReplyDelete
  3. For non technical user, it is not an easy task to repair Excel file mannually, i would recommend to such people, go for third party application, which is easy and fast way to repair corrupt excel file. Go to Google search there lot of tools available there, one such application is here:
    http://www.recoverydeletedfiles.com/excel-file-recovery-tool.html

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete