Excel xls or xlsx file after recovery

[VitorSoares]

Hi guys!

I decided to clean up my D drive and formatted it. Now I understand that it was a big mistake! But I still was lucky to recover most files with Power Data Recovery utility. Basically, all the files work fine, but some Excel files probably somehow damaged and cannot be opened. Is there a possibility to recover them? Thanks! 

[WAWood]

@VitorSoares

Hello;

Allow me to welcome you to the HP forums!

Most likely, the answer is no.  Files are linked blocks of data and if one or more of those blocks gets overwritten, the complete file can never be recovered.

IF you're willing to spend some money, you could try using Active@File Recovery Pro -- as I have found it to do the best job of recovering files.  But ... there is no guarantee that it will work.

Good Luck

[VitorSoares]

Oh, I'm sorry! but thanks for the answer!)

[ryanokelly]

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.

[ryanokelly · Accepted solution]

Also I recommended  for your situation try to use for corrupted excel file recovery software like Excel Recovery Toolbox.  This should help also.

http://www.oemailrecovery.com/excel_recovery.html

[VitorSoares]

Hi, Thank you all for your time and great help. I really appreciate your feedback and I am very thankful for your time and support.