Thursday, September 12, 2013

How to Recover Corrupted Excel Files!

How to Recover Corrupted Files in Excel
Sometimes many important Microsoft Excel Document can be damaged (corrupted) due to seaveral reason. Because Of such Document corruption you may have to fall in problem. So, you need to recover the corrupted excel files to avoid the problems. In this post I am gonna show how to recover corrupted excel files.


There are several methods that you can use to recover information from damaged or corrupted Microsoft Excel. Among them I am gonna show Open and Repair command method. It is also highlighted by Microsoft help center. Lets see how to do...


Recovering Corrupted Excel Files: This method is the primary method of file recovery in Excel 2003 and later versions. If you want to try to recover the most recent changes in a damaged Excel file, follow these steps:
  • First start the Excel program.
  • Then on the File menu, click Open.
  • Then in the Open dialog box, select the file that you want to open.
  • Then Click the arrow on the Open button, and then click Open and Repair.
    Excel open option
  • Then when you are prompted, click Repair to try to recover your most recent changes.

    Note:
     If Excel cannot repair your workbook, click Extract Data instead of Repair.
    • If your workbook contains formulas, Excel prompts you to select either Convert to Values or Recover Formulas.
    • 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?"

  • Finally Save your recovered workbook.


Stay with www.iTTimesbd.com for more IT related Post

No comments:

Post a Comment