Link to home
Start Free TrialLog in
Avatar of LockDown32
LockDown32Flag for United States of America

asked on

Need a Excel 2013 Password Recovery Tool

I have a customer who has forgotten a password to a Excel 2013 file. Need a reliable, proven password recovery tool. Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Wakeup
Wakeup
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LockDown32

ASKER

I don't really understand the scenario. A guy said he made a copy of a protected spreadsheet. At that point the copy had the same password as the original. He said he did a day of changes on the copy and now the password won't work.....

I don't see anything after failing the password try.
Here's something I found to be interesting and of value, but not able to try it myself.  I do not have 2013.  I make no guarantees that this will work or not.  I am not sure that this is damaging or not either.  As I do not code or develop.  But it appears to be safe from glancing with my limited knowledge.  Seek extra caution before trying?
https://community.spiceworks.com/canonical_answer_pages/9171-how-to-open-or-remove-password-protect-excel-file

"Press ALT +  F11 or click on View Code in Developers Tabs

      In the visual basic Enter the below Code. Do not change the code just copy paste:

      
      Sub PasswordBreaker()
          '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)
          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

      

      Now Click on the Run Button or press F5:"
I found that but the instructions were such a waste the couldn't be followed. They are assuming you know the developer tools and VB. My first questions was.... do you do the alt F11 after trying to open the spreadsheet and failing the password or what? It might work but the instructions need a ton more work.....
If i read it correctly you should be able to see your recently opened spreadsheets and right click on the one in question.... The do the alt f11 etc.
That is the initial problem. I couldn't tell if you were supposed to try and open it then have it fail at the password or what. The issue here is that the computer I am using has never opened that spreadsheet so it isn't in recent....
This commercial "Freeware" tool has worked for a client of mine that had a similar problem to yours: https://www.systoolsgroup.com/password-recovery/excel.html

Here's another freeware solution I found that may be worth a try: http://www.freewordexcelpassword.com/
DISCLAIMER: This product I have not tried myself, so try at own risk.

I hope that's helpful.

Regards, Andrew
I see and you are unable to get to the originating computer? Bummer...hmmm.  I'm not sure what else to try.  Hopefully Andrew's suggestion with help.
Thanks guys but same as 5 years ago. Not worth the time. Most of the links above were programs that wouldn't touch 2013 and the other suggestions didn't work. Not worth the effort.