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 Fotolia.com)

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:
Easy

Other People Are Reading

Things you need

  • Excel password macro

Show MoreHide

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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