Thursday, September 4, 2014

3 ways to recover corrupt Excel workbook!


MS Excel application is one of the best applications for storing data. It comes with fluent user interface that help you in finding powerful tool when you need them. It import, organize and explore massive data sets within considerably expanded spreadsheets and many more. However, excel files are prone to corruption like other computer files. So, here you will learn how to recover your corrupt excel files.


Method 1

Ms Excel comes with inbuilt utility known as “Open and Repair”, you can use it to recover your Excel files. Below are the steps just follow it:

1 – Go to File Menu, then click Office button and select Open.
2 – Select the corrupt spreadsheet.
3 – From the open button’s drop down list, you need to select Open and Repair.
4 – Now click on Repair button of the dialogue box to allow repairing of Excel file.
If still you face the problem with excel files then go for next method.

Method 2

If corruption occurs while you are spreadsheet was open then you don’t need to save the file, instead you need to save corrupt excel sheet along with the most recent changes. However you can restore your files by following the below steps:
  1. First select the open from the file menu. For Excel 2007 you need to click on Office button and select Open.
  2. Then you can use Look in control you need to locate or specify the corrupt workbook.
  3. Then click to open it.
If problem still occur, follow next method.


Method 3

If the Excel file does not get open with its own with “Open and Repair” option then you required to try setting the calculation method to try it manually.
  1. Open the new blank workbook.
  2. Then from the Tools menu select the option and click the Calculation tab.  For Excel 2007, click the Office button then click on Excel Options, and select Formulas in the panel that is at the left.
  3. In the Calculation section (Calculation Options in Excel 2007), you need to click on manual method.
  4. Then click on Ok.
Then you need to try to open the corrupt workbook. 

Tool we recommend

If none of the above method helps you in repairing and restoring your corrupt Excel files, then you can use worldwide used popular Excel File Repair. It is an efficient file that will help you in recovering your corrupted or damaged Excel file easily and quickly.

0 comments:

Post a Comment