repair excel workbook

Are you facing a problem while working with the Excel workbook? Or your excel file started behaving abnormally? Looking to fix the corrupted or damaged excel file and restore excel worksheet data. Then you are in the right place. Here in this article follow the easy 5 ways to repair and recover corrupted excel workbook free of cost.

Reasons Behind the Corruption of the Excel Workbook:


There are many unexpected reasons that make the excel file damaged or corrupted and as a result, the data become inaccessible. Here follow some of the common reasons faced by the user in daily life:

  • Sudden power failure or an unexpected damage of power equipment
  • Virus/malware infection
  • Any kind of defect in the Excel application
  • Hardware failure
  • Abruptly system shutdown can damage the excel file
  • Sudden close in the Excel file can corrupt the workbook
  • Bad sector in the storage media


Ways to Repair Damaged Excel Workbook


Here follow different easy manual ways to repair the excel workbook.

Not happy with your MS Excel performance?
Don't Miss The BEST TOOL To FIX .xls/.xlsx Errors & Issues

1. Try Open & Repair Utility:


Utilize the inbuilt Open and Repair utility. Follow the steps below to make use of it:

  • Choose Open from the File > click the Office button > select Open if you are working in Excel 2007.
  • With the use of Look In Control option, locate and specify the workbook which has been corrupted.
  • From the drop-down list of Open button, choose Open And Repair option as shown in the Image A.
  • After that click Repair in the resulting dialog box as shown in the Image B.

Image A

recover corrupted workbook


Attempt to Manually recover the corrupted workbook.

Image B

recover corrupted workbook

Excel will easily repair the file if you are lucky. This feature only repairs the minor corruption and fails to repair the severely damaged file so if you are unable to fix the excel file then follow the second solution.


Also Read: 

  1. 13 Inexpensive Ways to Fix Corrupt Excel File Assuredly
  2. Best Solution to Repair Excel XLS, XLSX, XLT, XLS, XLSM, XLSX on Windows or Mac
  3. How to fix “The file is corrupt and cannot be opened” excel error
  4. Fix Excel Error “Invalid XLS File Format” On Windows OS
  5. How to Repair and Restore Damaged XLS and XLXS File


2. Avoid Saving the Workbook:


Corruption can take place when the workbook is open? If, this happens then do not save the workbook, simply revert to the last saved version because reverting to the last saved version, will discard the corrupted component. With this, you will simply lose the data but possibly you can rebuild it quickly.

Reverting to the last saved version:

  • Choose Open from the File Click the Office button and select Open if you are working in Excel 2007.
  • With the use of Look In Control option, locate and specify the workbook which has been corrupted.
  • Hit the Open


3: Disable Automatic Calculation


If Excel still fails to open the file on its own or through the Open And Repair option, then try setting the calculation method to manual and try again. In order to reset the calculation setting, follow the steps:

  • Open a new blank workbook.
  • Choose Options from the Tools menu and then click the Calculation Now click the Office button then click Excel Options and then at last select Formulas in the panel to the left.
  • Now click Manual in the Calculation section.
  • Simply hit OK.

Now try to open the corrupted workbook. Sometimes Excel can open a corrupted workbook if there is no need to recalculate.


4: Try Microsoft Office Tools


If Excel can’t open the corrupted workbook then make use of the Microsoft Office Tools, follow the steps to do so:

  • Choose All Programs from the Start
  • Select Microsoft Office.
  • Choose Microsoft Office Tools.
  • Select Microsoft Office Application Recovery.
  • Choose Microsoft Office Excel in the resulting dialog box as shown in Image C.
  • Click Recover Application. This process will take few minutes.
  • Now simply respond to the Send Report To Microsoft prompt.

recover corrupted workbook

This recovery tool will quit the Excel and then it will allow your Excel to restart along with displaying a list of recovered workbooks. If your workbook will be recovered then you will get it in the available list.


5: Move the File


Most of the times, a corrupted workbook is not actually corrupted, it just become inaccessible. If you find that your Excel can’t recover your corrupted workbook then just move the corrupted file to another folder, server or drive.

These are some of the common and the most effective ways that can be applied to recover the corrupted Excel workbook. If the above ways don’t work then make use of the other alternative MS Excel Repair Tool. This tool is the efficient way to recover corrupted excel workbooks in all scenarios.


Alternate Solution to Retrieve Excel Workbook


Make use of the professional recommended MS Excel Repair Tool, this is designed with the advanced algorithm to repair all sort of damages, corruption, and errors in the excel file. It is a unique tool that repairs multiple corrupted excel file at one time and also recovers everything included charts, cell comments, worksheet properties and other data. With the help of this user can recover corrupted excel workbook data to a new blank file. It is extremely easy to use even a novice user can use it and supports both Windows as well as Mac operating system.

Excel Repair for Windows     Excel Repair for Mac


Steps to Utilize MS Excel Repair Tool:





Hope by following the given solutions you are able to repair and recover the corrupted, damaged excel workbook easily. Try the solutions one by one and fix the excel file but if none of the manual solution help then, in this case, you can make use of the third party MS Excel Repair Tool.

Good Luck!!!

5 Easy Ways to Repair & Recover Corrupted Excel Workbook Without Spending Money
5 Easy Ways to Repair & Recover Corrupted Excel Workbook Without Spending Money
Article Name
5 Easy Ways to Repair & Recover Corrupted Excel Workbook Without Spending Money
Here follow 5 manual ways to repair and recover corrupted excel workbook easily. Utilize open and repair, or disable automatic calculation and much more
Publisher Name
Repair MS Excel Blogs
Publisher Logo
  • 23