Thursday, 14 March 2013

How to fix damaged Excel Workbooks?

Excel is undoubtedly the most popular spreadsheet software and used by millions of people on daily basis. I also use it regularly to manage all my financial data and that is why I can say how painful it is for an Excel user to see his workbook corrupt. There is high risk of losing all the data if user is not smart enough to make a backup. But still there are many methods to repair a damaged Excel workbook that user can try.

Use Recovery option: If Excel suddenly stops responding then you can try MS Office Application recovery program to repair damaged Excel workbook.
  1. Go to start->All Programs-> MS Office-> MS Office Tools and select MS Office Application Recovery.
  2. Now go to Application list-> MS Excel-> Recover application.
  3. Open Excel and check your recovered workbook in Document Recovery taskpane.
Open & Repair:
  1. Open Excel.
  2. Go to File-> Open and select the file that you want to repair.
  3. Now click the drop down arrow of Open and select Open and repair command.


Set recalculation option to manual: If you are unable to open your Excel file then try below steps:
  1. Open Excel.
  2. Go to Excel Options-> Formula-> Calculation options.
  3. Select Manual.
  4. Now try to open the corrupt file.


Move the file to a different location: Sometime a corrupt file is not really corrupt means you can't open file due to some network or server error. So move your file to different drive or folder and try to open there.

Open corrupt file using free software: It has been observed that a corrupt file that you can't open in MS Office can easily be opened using OpenOffice Suite (free software). So try to open your corrupt Excel workbook in OpenOffice.

Open in WordPad: Try to open your workbook in WordPad. Using WordPad you will be able to recover only text not formulas. Still it's worth a try.

Save file in SYLK format: This method is used to remove printer corruption if any.
  1. Open Excel.
  2. Go to File-> Save As.
  3. Click SYLK in the Save as type list and then click Save.
  4. Go to File-> Open and select the file that you have saved in SYLK format and open it.
  5. Again go to File-> Save As-> Excel Workbook.
  6. Give a different name to your Excel file and save.
Note: Only current or active sheet is saved in SKYL format not the whole workbook. So you need to save each sheet separately in SKYL format.

Try third party tool: There are so may 3rd party Excel repair software available online. Download any of them from website and see what can they do for you. Almost all repair software have demo version that shows the preview of corrupt workbook.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...