how to repair damage excel file

dear all,
I have an Excel file its size about 19 MB and it was work properly, suddenly we can't open
this file, and it shows the message "unable to read file" , and even if after several attempts, it open then it is not open Properly.
Note that this file is protected with a password.
Is there a solution for this problem, please ?
best regards.

In order to repair the damaged excel file you have to perform the following steps:

  1. Open the excel file.
  2. Now select the corrupted workbook that you want to open.
  3. Then click on Open and Repair by clicking the arrow next to the Open button.
  4. Now perform any one of the following:
    • Click on Repair in order to recover the data from excel.
    • To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.
By following these steps, you can easily repair the corrupt Excel file. And if you find the above-mentioned steps complicated then, in that case, it can be recovered with the help of MS Excel Repair Software. Using this software, you can easily repair the MS excel file. Moreover using this software is very easy. For more information, kindly visit the web address mentioned below:

Repair corrupt Excel file data using Excel repair tool, this software allows the user to view preview of the recovered data that can be recovered and saved with full version of the software. To know more and download from here- You can go with DataRepairTools for repair Excel data items

You can repair corrupted and damaged Excel file, then you should try to open and repair function in MS Excel first. It is built-in repair function that help to fix corrupt .xls/.xlsx files and open. As it is a built-in feature, it has a drawback. It might not work then some corruption issues are there. In this situation, you can try a third-party Excel Repair Tool to repair corrupt MS Excel file after Excel file got damaged due to virus infected. So check out this link:

Hi @johnmicheal FYI You won't be able to attach links until you have made a few more messages. Don't get discouraged. You will be able to attach links soon!;)

There are several reasons for MS Excel file to get damaged such as virus attack, system malfunction, hard drive bad sector, shutting down file without closing your worksheet, software issues and so on. Most proper way of saving your file from corruption is to create proper back-up of your file but if you lack appropriate back-up then you can make use of Excel File Repair Tool.

I had a similar problem. Tried to recover the data Recovety Toolbox fox Ecxel, but failed ( Did I do something wrong?

Upd: This program does not support files with password. How to recover data with password?

Last edited:

Taylor Wallis

Well-Known Member
Before purchasing any such paid software, you must try the manual trick first. The good thing is that you don't need any paid tool or any other cost. All you need is Microsoft Excel and little time. You can read this blog post for complete information: Few Easy Tips & Tricks to Repair Excel File Manually | N. Sem's Blog

In this blog post, you'll learn how to repair Excel file manually. Instead of using a paid solution, you must try the manual tricks.

Thanks and best regards.

Well, it is estimated that the error is occurring due to the corruption so, try repairing the corruption with the help of the inbuilt Open and Repair utility. Read this: 13 Inexpensive Ways to Fix Corrupt Excel File Assuredly

However if this won’t help you then the problem might be caused due to antivirus running on your system. Even in some cases it is found that some of extra Excel file is replaced or modified the header of the document. The Extra text is sometimes added between the “Content Type” and “Content Location” sections of the file header, making it unrecognizable, thus unable to read while opening it with Microsoft Excel.

So, try disabling the antivirus software, also try to clear IE's cache and reboot your computer

This website is not affiliated, owned, or endorsed by Microsoft Corporation. It is a member of the Microsoft Partner Program.