how to repair damage excel file

FrancisHancock

New Member
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:
msexcel.filerepairtool,net/blog/ways-recover-corrupted-excel-workbook
 
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:
 
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:
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
 
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.

Yes, you can repair your Excel file by using these solutions:

Open and Repair (Repair and Extract Data)

Open MS Excel instance and select the file which you want to repair. Under manage option, select Open and Repair option.
First, go with the repair option and if it won’t work then, try extract data option.

Set calculation option as manual
  • Open MS Excel
  • File->Options->Formulas
  • Under Calculations option, Check manual radio button
  • Click OK
  • Go to File->Open
  • Open the corrupted Excel file
Trust Center setting update

Update trust center setting and try to open the Excel file. To update the trust center setting, follow these steps:
  • Open Excel instance
  • File->Options->Trust Center
  • Click on Trust Center Settings button
  • Unchecked all three options
  • Save all the changes
These solution are helpful to fix 'unable to read file' error. If these methods won't work then, try a third party Excel repair software to repair corrupt Excel file.
More References: Repair a corrupted workbook
 
Follow these steps to repair your file:
  1. Click File > Open.
  2. Click the location and folder that contains the corrupted workbook.
  3. In the Open dialog box, select the corrupted workbook.
  4. Click the arrow next to the Open button, and then click Open and Repair.
  5. To recover as much of the workbook data as possible, pick Repair.
I hope this helps!
 
Back
Top