Excel – Removing Passwords from Excel Protected Sheet or Workbook

Last week I had a spreadsheet with some data from a previous co-worker.  Unfortunately, he had password protected the spreadsheet, and I needed to look at his formulas to understand how he created his spreadsheet.

But I didn’t know what the password was!  After a painful few tries of trying to guess the password, I went to google and did some searching.  What I found was unbelievable.  This one guy created a free Xcel plugin that will remove the password from a protected worksheet and workbook!

I installed the plugin, and gave it a test run.  It came with two new options (Unlock worksheet and unlock workbook) underneath the Tools menu.  I ran it and within 10 seconds it said “Success!”

Guess what?  It frickin’ worked!  I was able to access the hidden data and see the formulas. ;0  My boss was so impressed that day, lol.

Check out the magical excel plugin here.

Posted on March 24, 2009, in Advice, Excel and tagged , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: