Fix corrupted xls and xlsx file after recovery

LawrenceHamilton

Beta member
Messages
2
Location
USA
Hi,
I formated my D drive but I have done by mistake. So I recover all data using Power Data Recovery many file working ok but some Excel file corrupted and unable to open. How can I fix it?
Thanks!
 
Could you put the file on a file sharing website? I could take a look at it.
 
First try File | Open ... browse for the file, then click the dropdown triangle on the Open button and choose Open and Repair. If it prompts, the "Repair" options is better, but if it fails, try again, choosing "Extract".
Then, check the size of the recovered file. Is it likely all your data is included? if so, you can try to access the data from the file without opening it by creating an external reference. In cell A1 of a blank workbook, type a reference to the A1 cell of the corrupted workbook, following this format:
='C:\Folder\Path\[FileName.xlsx]SheeName'!A1
Beyond that, what is the file format? There may be more options. Lots of help here:
How to open xls file? - TechRepublic
How to repair XLSX file content? - XLSX Repair Kit
 
Back
Top Bottom