Results 1 to 12 of 12
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Toronto, Ontario
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password Cracker for Excel

    Can anyone recommend a (preferably free) password recovery tool for Excel spreadsheets? I have 6 workbooks that were password protected by an employee who has since left our firm and the data is urgently required.
    <img src=/S/cooked.gif border=0 alt=cooked width=50 height=46> , TIA.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Password Cracker for Excel

    We've got and use Excel Key from LostPassword, but it costs money.
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker for Excel

    This was posted here in the lounge some time ago by one of the loungers ( I forget who!) and by making it a macro it works fine.



    Sub PasswordBreaker()
    'Author unknown
    'Breaks worksheet password protection.
    Dim I As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For I = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(I) & Chr(j) & Chr(k) & _
    Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
    Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    'It may be unnecessary to use the offered password
    If ActiveSheet.ProtectContents = False Then
    MsgBox "One usable password is " & Chr(I) & Chr(j) & _
    Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
    Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
    End Sub

  4. #4
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Password Cracker for Excel

    There is an addin called EDC Password Tool.xla that I have found useful, cannot point you to the site but a Google should find it. If my memory serves me this was free.
    For a modest cost I have found AOXPPR a good tool, being the IT Manager I too have had occasions where workbooks are urgently required but the person has since left. HTH
    Paul Coyle
    Approach love and cooking with reckless abandon

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Toronto, Ontario
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker for Excel

    Thanks Preston (I will keep your macro in case of future issues like this) and to John Gray and P Coyle for the responses. FYI: In Word 2002 if you have a document that was password protected in a previous version of Word but no longer have that password you can do Insert|File and voila! it is recovered. In Excel there is no option to Insert|File. However you can make that option available by customizing the toolbar. Choose Built-in Menu, File, drag to the desired location on the Insert Menu and you now have the option to insert a file. Navigate to where the document is located and open. No prompt to enter password and there you have it! the spreadsheet is recovered. Bit crude perhaps but got the job done.

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker for Excel

    Could such a "security" hole be an incentive from MSFT to purchase the latest version so you can recover stuff from earlier versions?

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker for Excel

    Does not work if I do the following:

    1. Create a workbook with Excel 2000.
    2. Lock all the cells and protect with password.
    3. Create empty workbook in Excel 2002.
    4. Use Insert | File to insert the workbook created in Excel 2000.

    Cells are still protected,

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker for Excel

    ASAP Utilities and Rob Bovey's Excel Utilities both have password protection removal tools. The latter of these is more lightweight, but both are <img src=/S/free.gif border=0 alt=free width=30 height=15>. I think they only remove protection at "sheet level", not for the VBA project - don't know if this is what you're after though.

    Looks like version ASAP 3.06 has just appeared, and my older version says it will stop working soon if I don't download the new one... off we go then <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

    Alan

  9. #9
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Toronto, Ontario
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker for Excel

    Thanks for that Alan. I'll be downloading them at the office tomorrow. I love <img src=/S/free.gif border=0 alt=free width=30 height=15>

  10. #10
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Password Cracker for Excel

    -John ... I float in liquid gardens
    UTC -7ąDS

  11. #11
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Password Cracker for Excel

    A bit late perhaps, but if all you need to do is to remove password protection from an open workbook, run the following macro against each sheet:

    Sub SheetPassword()
    ActiveSheet.Protect "", , , , True
    ActiveSheet.Range("a1").Copy ActiveSheet.Range("a1")
    End Sub

    Unless cell A1 is merged, it should work as is. If cell A1 is merged, change the cell reference to another (unmerged) cell.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  12. #12
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Toronto, Ontario
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker for Excel

    Our problem was we could not open the workbook without entering a password but I'm grateful for the reply nonetheless. Cheers,
    Paddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •