I have an Excel workbook.
Two years before I set password protection option for one of the sheets. Now I have forgotten the password. Is there any way to recover the password of that Excel sheet?
migrated from stackoverflow.com Sep 23 '09 at 21:06
This question came from our site for professional and enthusiast programmers.
You cannot recover THE password, but you can unprotect the sheet(The hash used to protect the sheet is quite prone to collisions in the old versions of excel, so generating a collision is quite fast here).
There are scripts availale the will brute force open your sheet within a very short amount of time.
Take a look here for example: http://www.theofficeexperts.com/VBASamples/Excel02.htm
Here's the code:
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?