Tech Dreams

How To Unlock Password Protected Microsoft Excel Workbooks

Remove Excel Passwords How many times have you forgot password of a Microsoft Excel workbook/sheet and then had a sinking face?

Microsoft Excel has a protection feature that allows users to lock a workbook or sheet with a password. When the Excel workbook/sheet is protected with a password, any user attempt to edit data shows an error message


Microsoft Excel Error Message When User Tries To Edit Password Protected Sheet

Here comes an handy Excel plug-in called Excel Password Remover 2008 which strip the password protection from Excel workbooks and spreadsheets. You can install the plug in by downloading it from here. Once installed, it adds options Unprotect workbook and Unprotect sheet to Excel’s Tools menu, and choosing these options does what they are meant to.

Download Excel Password Remover

Note: To install the plugin you should set security level of Macros to medium by following the menu Tools->Macros->Security in Microsoft Excel.

Related:  How To Convert Excel Columns To Rows And Vice Versa

13 Comments on How To Unlock Password Protected Microsoft Excel Workbooks

  1. Ajay M
    June 23, 2011 at 5:09 pm (8 years ago)

    This WORKS in Office 2007 too.

    Steps-
    a. Download the ‘Password.xla’ file to your desktop
    b. Open the file.
    c. You will get a popup to ‘Enable Macros’. Click Enable.
    You will get a confirmation that the Add-in has been installed. Click OK.
    d. Go to File> Open and open the file which has protected sheet or protected workbook.
    e. Once you have opened the workbook, Go to extreme right icon in ribbon- ‘Add -Ins’.
    f. Under ‘Add – in’s, you should be able to see 2 options each for ‘Unprotect Sheet’ and ‘Unprotect Workbook’. Click on them to remove the protection. At the bottom left corner of your Office 2007 window, you should be able to see the time taken to unprotect the workbook as ’00:00:17′ etc. Once unlocked, you will get a confirmation.
    g. Save the workbook.

    Regards,
    Ajay M

    Reply
  2. Gundam
    March 16, 2011 at 2:05 pm (9 years ago)

    It Works and its the fastest tool . So far I have tried couple of method including using the run macro but all of the failed.

    This one WORKS great !! Bravo a.

    Reply
  3. JASRSJ
    January 1, 2011 at 1:09 pm (9 years ago)

    I WANTS TO UNLOCK MY EXCEL ENTIRE WORK SHEET PASSWORD BUT NO CAN GIVE SATISFYING SOFTWARE.
    PLZ SUGGEST ME IF U KNOW BUT FOR FREE.

    Reply
  4. michelle
    July 26, 2010 at 6:43 am (9 years ago)

    excel password lost? Follow this tutorial to unlock password protected ms excel spreadsheet password:
    excel password lost? Follow this tutorial to unlock password http://sn.im/excelpwd

    Reply
  5. TJ
    December 25, 2009 at 1:05 am (10 years ago)

    The deal is, this one may work with excel 2007 with VBA converter hotfix. I can see the addon but I don’t manage to open my password protected file. I get dialogue box to enter password and that makes this menu inaccessible.
    But it DOES work with Excel 2007, install VBA converter hotfix.

    Reply
  6. Puli raju
    July 1, 2009 at 12:26 pm (10 years ago)

    Are IDIOT, every one know this. If you know how to unlock protected execl, then share with us.

    Reply
  7. Gopinath
    May 5, 2009 at 11:20 pm (10 years ago)

    This plugin works fine in Excel 5.0, Excel 2000, XP and 2003. As few visitors mentioned in the above comments, this plug in does not work with Excel 2007.

    Excel 2007 user: convert the file to Excel 2003 and then run this macro.

    Reply
  8. Linda
    May 5, 2009 at 11:09 pm (10 years ago)

    Have you tried saving the file to 2003 version and then use the password remover?

    Reply
  9. niño
    February 16, 2009 at 10:09 am (11 years ago)

    dont know how it works..

    Reply
  10. buah delima
    December 30, 2008 at 7:21 am (11 years ago)

    thanks for sharing…i usually forgot my password.
    hope this tools can help

    Reply
  11. Faraz
    December 23, 2008 at 10:20 am (11 years ago)

    Unfortunately, the book/sheet password remover addin from straxx.com doesn’t seem to be working for Excel 2007. Any other free resource?

    Reply

Leave a reply to Tania

Click here to cancel reply.