How to Unlock an Excel Password

By Ricky Gee

Microsoft Excel is a popular spreadsheet application that comes with the Microsoft Office software suite. It is possible to protect your Excel documents internally with a password. These protected files cannot be edited unless the password is entered. If you wish to unlock an Excel file that has been password protected, use a macro that reports a usable password string.

Step 1

Download an Excel macro designed to unlock passwords.

Step 2

Double-click "allinternalpasswords.xls" to open the macro. The workbook itself is hidden and the macro displays a toolbar.

Step 3

Click the "File" menu and click "Open ..." to open the workbook that you wish to unlock.

Step 4

Click the button on the toolbar to unlock the password. The macro provides you with a password that will work in the locked workbook.

Enter the provided password in order to unlock the workbook.

×