How to Unlock an Excel Password

Written by ricky gee
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Unlock an Excel Password
Microsoft Excel is a popular spreadsheet software application. (number background image by kuhar from

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.

Skill level:

Other People Are Reading

Things you need

  • Excel password macro

Show MoreHide


  1. 1

    Download an Excel macro designed to unlock passwords.

  2. 2

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

  3. 3

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

  4. 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. 5

    Enter the provided password in order to unlock the workbook.

Tips and warnings

  • 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.
  • A macro is a set of commands that carry out an automated task.
  • The macro does not provide you with the original password, but one that will work in the locked workbook.
  • Excel files that require a password upon opening cannot be unlocked with the macro.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.