Fix corrupted Excel xls or xlsx file after recovery

[deboer]

Hi Expert
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!

[AkseliKivela]

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\Pat h\[FileName.xlsx]SheeName'!A1
Beyond that, what is the file format? There may be more options.
See if the following article would help:

https://community.office365.com/en-us/f/172/t/256362

[deboer]

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