Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


kiwis

837 posts

Ultimate Geek
+1 received by user: 12


#24175 17-Jul-2008 09:14
Send private message

I have an excel sheet with a password which I have forgotten, is there a way i can unlock this??


Create new topic
nairda
140 posts

Master Geek
+1 received by user: 4


  #148759 17-Jul-2008 09:31
Send private message

A quick google using the keywords 'excel' and 'password' revealed a number of password crackers.  I haven't tried any of them though.



kiwis

837 posts

Ultimate Geek
+1 received by user: 12


  #148767 17-Jul-2008 09:59
Send private message

I should add, I can not download any sftware

tonyhughes
Hawkes Bay
8476 posts

Uber Geek
+1 received by user: 6

Retired Mod
Trusted
Lifetime subscriber

  #148769 17-Jul-2008 10:12
Send private message

kiwis: I should add, I can not download any sftware

Then you will not be able to find a solution unless someone can unlock this for you by having it emailed to them.

Why can you not download any software? If you are employed somewhere that has these kinds of lockdowns, then they probably should be able to help you get the tool you need to unlock the file if it is important.

Excel password hacking is apparently quite easy, but does require a bit of software to do the job.









chiefie
I iz your trusted friend
5877 posts

Uber Geek
+1 received by user: 151

Retired Mod
Trusted
Lifetime subscriber

  #148770 17-Jul-2008 10:12
Send private message

mysteriously... I found that (only once) that if you upload the XLS into Google Docs spreadsheet, it will open it regardless... We tried this once (only) with my colleague as he needed to get XLS opened in non-Office environment.

Alternatively, you could try open with OpenOffice if you have that.




Internet is my backyard...

 

«Geekzone blog: Tech 'n Chips Takeaway» «Personal blog: And then...»

 

Please read the Geekzone's FUG

 


BobW
90 posts

Master Geek


  #148771 17-Jul-2008 10:12
Send private message

Which version of Excel?  Recent versions have better password protection so are much more difficult to break.

Most likely you'll need to download a brute force password finding tool.  The free versions of such tools will typically only tell you the first 2 or 3 characters of the password, after that you need to buy the tool.  If it is your spreadsheet, then the first 2 or 3 characters might be enough to remind you what the password is.

BobW
90 posts

Master Geek


  #148777 17-Jul-2008 10:25
Send private message

What exactly is password protected?  Is it opening the file, the sheets once the file is open, or the VBA code?

Password protection on sheets is almost trivial to break.

Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.