Need a Excel 2013 Password Recovery Tool

LockDown32
LockDown32 used Ask the Experts™
on
I have a customer who has forgotten a password to a Excel 2013 file. Need a reliable, proven password recovery tool. Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Specialist 1
Commented:
Is the document readable and just not editable?  Perhaps duplicating the Excel document's contents into a new Excel document.
If it is not readable, then not much else you can try that I know of.
LockDown32Owner
Top Expert 2016

Author

Commented:
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.
WakeupSpecialist 1

Commented:
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:"
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

LockDown32Owner
Top Expert 2016

Author

Commented:
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.....
WakeupSpecialist 1

Commented:
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.
LockDown32Owner
Top Expert 2016

Author

Commented:
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....
Andrew LeniartIT Professional | Freelance Journalist | Looking for Opportunities
Distinguished Expert 2018

Commented:
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
WakeupSpecialist 1

Commented:
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.
Top Expert 2013

Commented:
LockDown32Owner
Top Expert 2016

Author

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial