- Copy all the data from the sheet and create a new sheet. This is quite simple method but this won’t work for sophisticated excel sheet with many formulas and reference.
- To create the macro which can retrieve the password and run it.
If you decide to use the second method, here are the steps.
First go to Developer tab, then click Macro. (For excel 2003 or below, go to Tools --> Macro --> Visual Basic Editor.)
Then you’ll see the following dialog, just type some name, I use “test”, then click on create.
Then copy paste the following code.
After that click on Play button as shown in screenshot below.
That’s it! You should be able to see your forgotten excel sheet password in the popup window.