Saturday, November 3, 2012


There are several passwords in Excel. The 3 first on this list are covered by the Excel Password Remover:

1. A password for each sheet that protects cells from editing and/or viewing
2. A workbook structure password to protect hidden sheets and the sheet structure of the workbook
3. A sharing password for shared workbooks (not so commonly used)
4. A password to open your workbook. For 97/2000/XP/2003-files I can recommend this one: Excel Password Recovery Lastic. Excel Key can also do that, but also attempt password recovery of Excel 2007/1010 files.
5. A password that protects the VBA code. Solutions here and here
Excel Password Remover removes the password protection applied by the “Protect sheet” and “Protect workbook” commands in Excel (i.e. enables you to edit the workbook even if you have forgotten your password).

It works on the active workbook, so you must be able to open the workbook in question.

It will remove passwords of any length, also passwords containing special characters. The free version is for personal use only. The PRO version is for business users, and others wanting the extra functionality.

Pro Version for MSOffice 2003:

Filetype : .xlam
Download Times : 6545564
Rating : 5:5

Pro Version for MSOffice 2007:

Filetype : .xlam
Download Times : 56564585787
Rating : 5:5

Pro Version for MSOffice 2010:

Filetype : .xlam
Download Times : 5427
Rating : 5:5


This program works on the active workbook in Excel.
This program gives you 2 or 3 new menu items in Excel:
1) Unprotect sheet
2) Unprotect workbook
3) Unprotect all (PRO version only)
The first two removes protection from active sheet/workbook, and the PRO version displays a password that works (most probably not the same as the original).
“Unprotect all” removes workbook protection (applied with “Tools”-”Protection”-”Protect workbook”) and all worksheet passwords in the active workbook. It displays no message at the end, it just stops running.
When the program is running, look to the Excel status bar (on the lower left) which will display the running time.
If Excel appears to freeze, just let the macro do its work. It may take up to a few minutes in Excel 2007, in Excel 2010 it is very fast (usually within a second).

Instructions for pre 2007 versions of Excel
Loading this add-in in Excel gives you the extra menu-items on the bottom of the “Tools”-menu (or equivalent in non-English versions of Excel).
To load this add-in in Excel: Open it the same way you do with Excel workbooks. Installing the add-in does not work for all users.

Instructions for 2007 and 2010 versions of Excel
You must enable macros when you open the workbook if asked.
If not there are two alternatives:
1. Add the location of password*.xlam to the trusted locations.
Under “Excel options”-”Trust center”-”Trust center settings…”-”Trusted Locations”-”Add new location”, add the path to where password*.xlam is stored
2. Set your macro security level one step down.
Under “Excel options”-”Trust center”-”Trust center settings…”-”Macro settings”, set the level down to “Disable all macros with notification”
Close Excel, start Excel and open password*.xlam
The image below shows the new menu items: