How to Recover Damaged Excel Workbooks

Spreadsheets and graphs on a desk

It’s often a user’s worst nightmare to find that an important workbook suddenly won’t open, mostly due to the fact that such files are irretrievably corrupted, but there are a few steps you can take before you decide to start over from scratch with your spreadsheet. 

Excel generally launches File Recovery mode when a workbook cannot be opened cleanly. This consists of the prompt shown in step 4 of Figure 1. However, you can also manually launch File Recovery Mode for any spreadsheet that you wish, as shown in Figure 1:

  1. Click once on the affected file within Excel’s Open dialog box.
  2. Click the arrow at the right-hand side of the Open button to display a menu.
  3. Choose Open and Repair.
  4. Choose Repair.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

BONUS: If you register now you can opt to receive a digital copy of "Transform" , Richard Francis' new book for growing firms when it's available on March 30th.

About David Ringstrom, CPA

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.


Please login or register to join the discussion.

Jul 23rd 2017 06:31

If you Excel workbook deleted and you want to recover them here is article on How to Recover Damaged Excel Workbooks.Thanks to admin for sharing marathi attitude status

Thanks (1)
Aug 18th 2017 10:12

After using Open and Repair tool, the problem still appears, it means your Excel file is highly corrupted and as we know Open and Repair unable to fix a major level of corruption.

So, in that case, I would like to recommend you one of the best solution i, e; Kernel for XLS Repair Tool to repair highly corrupted or damaged Excel file. This tool is capable to fix all types of issues. Try now :

Thanks (0)
Aug 30th 2017 02:54

most visit Punjabi Status

Thanks (1)
Aug 30th 2017 04:00

This is awesome article and I found it very help in my daily life.I will also Shareit on Whatsapp hindi Status and Facebook

Thanks (1)
Nov 10th 2017 18:10

amazing tutorial!! Very Helpful Happy New Year

Thanks (0)