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.

1

Download an Excel macro designed to unlock passwords.

2

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

3

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

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.

5

Enter the provided password in order to unlock the workbook.

Tips

  • check Unlocking an Excel file that you do not own may be illegal. Only unlock Excel documents when you have forgotten your password or are instructed to do so.
  • check A macro is a set of commands that carry out an automated task.
  • check The macro does not provide you with the original password, but one that will work in the locked workbook.

Warning

  • close Excel files that require a password upon opening cannot be unlocked with the macro.

Items you will need

About the Author

I hold a bachelor's degree from the University of Central Florida where I majored in interdisciplinary studies and minored in digital media. My areas of study were computer science and business administration. I run a freelance computer repair business where I perform repairs either in-house or at customer's homes. I also have been writing professionally as a freelancer for three years -- specializing in technical writing.

Photo Credits

  • photo_camera number background image by kuhar from Fotolia.com