Excel password

[Dolby]

I hear everyone mention how easy it is to get past the Excel password ... but I need to urgently edit this sheet which is blocked.

Any programs I could use?

 

[shiram]

I have used AOPR (Advanced Office Password Recovery) in the past for Excel 2003-format workbooks (xls), not sure how it works for 2007-format (xlsx).

 

[pmbellis]

You need to provide more info.

Excel file version (2003, 2007, other)

What is blocked? i.e. file open, sheet protection, VBA Project ... ??

Most of the downloadable tools are "demo only" & are useless for any real use. Do you know how LONG the password is?

 

[Dolby]

Excel 2007 ... Its sheet protection.

No idea on the length - but its set by a non technical, so probably normal letters under 10

 

[ChilliGirl]

is it a single sheet?

2007

then select the info on the sheet. Paste to new clean sheet/workbook & save under a diff name.

 

[Sting]

A more complex way - worked for me...
http://jsbi.blogspot.com/2008/09/how-to-easily-unprotectremove-password.html

 

[Dolby]

3 seperate sheets ... All linked via formulas etc. Only way would be cracking.

Thought it was so easy though :/

 

[bekdik]

ask the owner

 

[Dolby]

She's unavailable :/ Quite difficult ...

 

[ChilliGirl]

Are the sheets in one workbook? then you could try copy data/formula & paste into new.

or try save it as 2003. then edit & save results under new name. 2003 allowed you to edit but wont save file on same name.

 

[Dolby]

I found a macro that strips worksheet passwords - which is cool as its not imperative to know the orginal password

 

[prod]

I heard you can open the workbook with OpenOffice and re-save it to get rid of the passwords. Not sure though.

 

[memakda]

PM your email address
I have a file that has helped in the past