toolbar powered by Conduit

Sunday, September 7, 2008

Unprotect Excel Worksheet : Crack Password

Sometimes we come across an Excel file that can be opened and viewed but can’t be edited, since it is has been protected? And when we try to unprotect, it asks for a password.


Here are a couple of ways to overcome the problem.

Scenario 1: If the cells that you are interested in are selectable, then you can create editable copies by simply selecting the cells, copying the contents, and pasting them into a new worksheet or file. The new worksheet would be perfectly editable. While, this may appear too simple, many people are not aware that this works.
Scenario 2: There is a possibility that the creator of the file has disabled cell selection while protecting the worksheet. Obviously you can’t use the first method to deal with such worksheets, because without the ability to select the cells you can’t possibly copy the contents. A better way to find the password is described in JE McGimpsey's site: http://mcgimpsey.com/excel/removepwords.html which provides a macro to extract the password and unprotect the worksheet.

15 Comments:

Alisha said...

Hi,

I'm Alisha from Wowzio, and I'm excited to tell you about our new widget platform that helps bloggers increase readership by providing engaging widgets containing your blog's rich content. You can check out widgets customized for your blog here:

Wowzio Widgets for your Blog

I wanted to reach out to you to ask for your feedback on these widgets (feel free to install them on your blog, if you feel they are a good fit). I'm sorry for leaving this message via a comment, it's not at all our intent to spam you ( which is why i'm leaving this comment on an older post and you can always remove this comment ). Again, we would love to hear your feedback.

Thanks,
Alisha Wright
alisha.wright1@gmail.com

Anonymous said...

Before , I was confronted with the Excel password problem. Finally , my friend Fiona recommend the Excel password unlocker .It helps me access my password protected excel files.I think it is a good excel password recovery tool.
http://www.password-unlocker.com/

buy viagra said...

viagra online
generic viagra

Generic Viagra said...

I think this blog is pretty cool,it has a lot of good and interesting content about "Unprotect Excel Worksheet: Crack Password",good for you I hope you can add more useful information and upgrade your site,I really like it

Alex said...

In ms excel I often do reports, but some days ago I lost all my reports for some seconds on undetermined cause. I was terribly upset. Only yesterday I luckily dug up a program, which assisted me. What is more it would aid in almost every similar trouble too - the file is not in recognizable format in Excel.

moshsrv said...

awsome many thanks

generic viagra said...

Thanks for a marvelous posting! I seriously enjoyed reading it, you can be a great author

aisha said...

Dodge Pick-Up Turbocharger
I like it because i was seeking for such type of info.
I hope it benefits all one who land up here.
Thanks for sharing!!

Vince said...

Incredibly awesome.

Anonymous said...

Really good!

Anonymous said...

you can also use various sites to find excel sheet password without donwloading or uploading anything.

Anonymous said...

damn it won't work if you have password to OPEN spreadsheet! I had to pay $20 to online service www.password-find.com for password crack! thank God, they removed it instantaneously

Aaron Bentley said...

It is possible that you face distinct kind of issues regarding prospect PST files the good news is it is not the so big issue for any person because everyone should know the program. Keep it up.
pst recovery

jack Methue said...

This blogger has some tips to recover excel password but there is no manual process to recover or crack excel password so the best option is to use microsoft office password recovery software which is free for trail and easy to use due to its user friendly feature. I have used this tool so someone can also try for it.

Priyanka Kumari said...

Thank you for nice posting. I have used this office password recovery and now i am able to recover my lost MS Excel password.