SOLVED

Corrupted Excel File

%3CLINGO-SUB%20id%3D%22lingo-sub-1792664%22%20slang%3D%22en-US%22%3ECorrupted%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792664%22%20slang%3D%22en-US%22%3E%3CP%3EA%20password%20protected%20excel%20file%20was%20saved%20as%20a%20back%20up%20in%20an%20external%20hard%20drive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThereafter%20on%20attempting%20to%20open%20it%20using%20the%20correct%20password%20it%20says%20%22%3CSTRONG%3EThe%20file%20is%20corrupted%20and%20cannot%20be%20opened%3C%2FSTRONG%3E%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20be%20obliged%20if%20there%20is%20any%20way%20to%20recover%20the%20file%20as%20it%20has%20very%20important%20stuff%20therein.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1792664%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792749%22%20slang%3D%22de-DE%22%3ESubject%3A%20Corrupted%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792749%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F836448%22%20target%3D%22_blank%22%3E%40TriqAz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThere%20are%20a%20few%20things%20you%20could%20try%20but%20you%20would%20have%20to%20have%20the%20file.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EAt%20the%20same%20time%2C%20decrypting%20a%20file%20that%20does%20not%20belong%20to%20you%20can%20be%20a%20criminal%20offense.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EA%20very%20sensitive%20situation%2C%20especially%20when%20it%20comes%20to%20sensitive%20data.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EA%20worksheet%20can%20be%20opened%20easily%2C%20a%20file%20can%20be%20a%20bit%20difficult.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EYou%20might%20need%20additional%20software%20to%20manage%20this.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EEverything%20is%20possible%2C%20but%20everything%20is%20not%20allowed.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20an%20example%20of%20how%20to%20unlock%20a%20worksheet.%3C%2FP%3E%3CP%3E'CAUTION%20only%20to%20be%20used%20for%20your%20own%20Excel%20sheets!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792791%22%20slang%3D%22en-US%22%3EBetreff%3A%20Corrupted%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792791%22%20slang%3D%22en-US%22%3EHi%20Nikolino%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20certainly%20is%20MY%20OWN%20file%2C%20thanks%20for%20the%20concern%20and%20the%20tip.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20noticed%20your%20tip%20mentions%20about%20removal%20of%20password.%20I%20know%20the%20password%20very%20well%20and%20am%20entering%20it%20correctly%20but%20it%20shows%20as%20%22...%20Corrupt%2C%20and%20cannot%20be%20opened%22.%20Hence%20the%20reach%20out.%3CBR%20%2F%3E%3CBR%20%2F%3EWould%20you%20review%20your%20advise%20please%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792841%22%20slang%3D%22de-DE%22%3ESubject%3A%20Corrupted%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792841%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F836448%22%20target%3D%22_blank%22%3E%40TriqAz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EUnfortunately%2C%20the%20translation%20came%20across%20as%20if%20the%20password%20were%20the%20problem.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EHowever%2C%20if%20it%20is%20a%20question%20of%20damaged%20Excel%20files%20and%20not%20about%20passwords%20then%20you%20can%20find%20information%20here.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThis%20method%20of%20repairing%20Excel%20files%20works%20as%20of%20Office%202003.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EStart%20Excel%20on%20your%20computer.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ENow%2C%20depending%20on%20the%20version%2C%20click%20on%20%22File%22%20or%20the%20%22Office%22%20button%20at%20the%20top%20left%20and%20select%20the%20%22Open%22%20item.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ENow%20select%20the%20desired%20Excel%20file%20and%20click%20on%20the%20arrow%20next%20to%20%22Open%22%20(see%20picture).%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EHere%20click%20on%20the%20item%20%22Open%20and%20Repair%22.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EConfirm%20the%20query%20by%20clicking%20on%20%22Repair%22.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EAn%20attempt%20will%20now%20be%20made%20to%20repair%20the%20Excel%20file.%3C%2FSPAN%3E%20%3CSPAN%3EIf%20this%20is%20successful%2C%20save%20the%20file.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIf%20an%20error%20occurred%20or%20the%20file%20was%20not%20repaired%2C%20try%20the%20process%20again.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EIn%20the%20final%20query%2C%20however%2C%20do%20not%20click%20on%20%22Repair%22%20but%20on%20%22Extract%20data%22.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EThe%20file%20should%20now%20be%20repaired%20at%20the%20latest.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CP%3E%3CSTRONG%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Eadditional%20information%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FDIV%3E%3CP%3E%3CFONT%20size%3D%223%22%3ERepair%20a%20corrupted%20workbook%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frepair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frepair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EOf%20course%20there%20are%20also%20tools%20that%20you%20can%20buy%20additionally.%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%3Esuch%20as%20Wondershare%20(Stellar%20Excel%20Repair%20Tool)%2C%20recovery%20toolbox%2C%20etc.%20can%20be%20found%20and%20bought%20on%20the%20Internet.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*The%20third-party%20products%20that%20these%20article%20discusses%20are%20manufactured%20by%20companies%20that%20are%20independent%20of%20me.%20I%20makes%20no%20warranty%2C%20implied%20or%20otherwise%2C%20about%20the%20performance%20or%20reliability%20of%20these%20products.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWish%20you%20a%20nice%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

A password protected excel file was saved as a back up in an external hard drive.

 

Thereafter on attempting to open it using the correct password it says "The file is corrupted and cannot be opened"

 

Would be obliged if there is any way to recover the file as it has very important stuff therein.

 

7 Replies

@TriqAz 

There are a few things you could try but you would have to have the file.
At the same time, decrypting a file that does not belong to you can be a criminal offense.

A very sensitive situation, especially when it comes to sensitive data.

A worksheet can be opened easily, a file can be a bit difficult.

You might need additional software to manage this.

Everything is possible, but everything is not allowed.

 

Here is an example of how to unlock a worksheet.

'CAUTION only to be used for your own Excel sheets!

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Hi Nikolino,

It certainly is MY OWN file, thanks for the concern and the tip.

I noticed your tip mentions about removal of password. I know the password very well and am entering it correctly but it shows as "... Corrupt, and cannot be opened". Hence the reach out.

Would you review your advise please?

@TriqAz 

Unfortunately, the translation came across as if the password were the problem.
However, if it is a question of damaged Excel files and not about passwords then you can find information here.

 

This method of repairing Excel files works as of Office 2003.

Start Excel on your computer.
Now, depending on the version, click on "File" or the "Office" button at the top left and select the "Open" item.
Now select the desired Excel file and click on the arrow next to "Open" (see picture).
Here click on the item "Open and Repair".
Confirm the query by clicking on "Repair".
An attempt will now be made to repair the Excel file. If this is successful, save the file.
If an error occurred or the file was not repaired, try the process again.
In the final query, however, do not click on "Repair" but on "Extract data".
The file should now be repaired at the latest.

additional information

Repair a corrupted workbook

https://support.microsoft.com/en-us/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801dd...

 

Of course there are also tools that you can buy additionally.
such as Wondershare (Stellar Excel Repair Tool), recovery toolbox, etc. can be found and bought on the Internet.

*The third-party products that this article discusses are manufactured by companies that are independent of me. I makes no warranty, implied or otherwise, about the performance or reliability of these products.

 

Thank you for your understanding and patience

 

I would be happy to know if I could help.

 

Wish you a nice day.

 

Nikolino

I know I don't know anything (Socrates)

@Nikolino Thanks a lot for your efforts, but it's just not happening despite trying all the alternatives as per advice. Shall try buying any of those software and attempt. Maybe I would succeed.

Thanks anyways. Much appreciated.

Best Response confirmed by TriqAz (New Contributor)
Solution

@TriqAz 

 

Maybe try it with this tool is a Free Trial version, if it works you can still buy it.

https://advanced-excel-repair.soft112.com/

The third-party products that this article discusses are manufactured by companies that are independent of me. I makes no warranty, implied or otherwise, about the performance or reliability of these products.

 

Thank you for your patience and time.

 

Nikolino

I know I don't know anything (Socrates)

@Nikolino Thanks but it too failed to repair

 

Appreciate your support a lot. Many thanks.

I am sorry your file is no longer repairable.

I wish you a nice day / night with health, joy and love.

Nikolino
I know that I know nothing (Socrates)