Tuesday, May 06, 2008

Unlocking password protected Excel files

Ever got into any of the following situations
  • You have password protected an Excel file and have subsequently forgotten the password
  • Got an excel file that is password protected and you want to access the contents of the file
Today I was in the first situation and after a bit of googling I came across the following application Excel Password Remover 2008 which is an add-in to excel.

It's very simple to use this tool
  • Download the add-in password.xla and save it at any location on your hard disk.
  • Load the add-in into excel by going to the following menu option Tools -> Add-Ins. Click on Browse in the window that pop-ups and find the password.xla file that is saved on your hard disk. It will then appear in the add-ins Available list. Make sure the checkbox next to the name of the add-in is checked before you click on ok. Once you click on OK you should get two new menu items in the tools menu Unprotect sheet and Unprotect workbook.
  • Open the file that you want to unprotect (note that you cannot use this tool to open excel files that are password protected to even open them. There are other suggested tools on the website but I have not tried them out). Click on Tools -> Unprotect Sheet and after a few seconds you will get a message that the sheet is unprotected.
  • Once you have unprotected all the sheets save the file to your hard disk and all the password protection would have been removed.
There is a negative side and positive side to such a tool
  • Password protecting excel worksheets is really not helpful as you can easily break the password.
  • You don't have to worry if you forget the password as there are tools such as this that can break it. The worry was there as Microsoft never gave a method of recovering the password if it was forgotten. I think password protection is a half baked solution they implemented in Excel.

3 comments:

mberi1981 said...

Hi, I wanted to refer to your blog in my blog which I am writing about “How blogging, Online visibility is going to help Outsourcing and create more business.” I understand that the question would be why your Blog as it is totally disparate and yes that is the reason I wanted to highlight that there are enough individuals who have a passion of sharing online and Blogs can be channelized for professional growth and not just personal networking or as a personal channel. I would post my blog under an interesting competition going on with a chance to win $1000 (http://www.limeexchange.com/contest/details/2). Is it going to be alright with you?

Anonymous said...

@mberi1981 : Please go ahead and refer to my blog in your post for limeexchange. All the best in the competition.

All the best once again and I would appreciate it if you can send me a copy of the article and if it is in line with my thoughts I will post a link to it on my blog if it is okay with you.

I managed to find your blog @ its new home (http://lakshvivek.com) and it looks very impressive. It would be good if you can make a note on your google profile that this is the new home of your blog so that it can be found easily.

Unknown said...

It is very easy through Excel password unlocker software to unlock password protected Excel files. Excel password recovery software smartly recover Excel password.

You do what you are

In the 2001 movie Along came a spider, there is an interesting quote by Morgan Freeman where he says "You do what you are" and the...