Crack Excel Password

How to Crack Excel Password Quickly with 3 Easy Ways

August 15, 2019 02:31:47 / Posted by Michael Eric to Office Tricks
Follow @MichaelEric

"How do I crack an Excel 2016 password-protected file? I have tried changing the ZIP but it doesn't work."

If you want to open a password protected Excel file but you do not have the password, you will need to crack Excel password to open the file. If you would do a search on Google regarding how to do it, you will come across dozens of guides telling you different ways to open your Excel files without entering a password. Unfortunately, many of those guides do not work and you cannot crack your Excel passwords using those methods.

Fortunately, there are still some methods that let you crack Excel file password with a bit of an effort. You can use these methods when you do not have access to premium services that guarantee the recovery of your passwords. The following guide covers three ways for you to crack Excel sheet password on your computer.

Part 1. How to Crack Excel Password Free without Any Software

There are users who prefer using third-party software to do their tasks and then there are other users who would not prefer to download or use any software. If you belong to the latter category, we have got some good news for you.

There are two ways that you can use to crack protected Excel sheet without using any software on your computer. Both of these methods work using the built-in options on your computer so you do not need to download or install anything on your machine.

1. Using VBA code to crack Excel workbook password

The first method uses a VBA script that cracks the Excel workbook password for you. The following shows how you use it on your computer.

Step 1. Launch the password protected spreadsheet in the Excel software on your computer.

Step 2. Press the Alt + F11 keys simultaneously to open the VBA code editor in the software. Enter the following VBA code to crack Excel workbook password into the editor and run the code.

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

vba code break excel

Step 3. You should see the password for your Excel file on your screen.

cracked excel password

Enter this password when Excel prompts you and you will be able to view the contents of the spreadsheet on your computer. That is how to crack Excel password using a VBA code.

2. Use ZIP software to crack Excel file password

Another method you have requires you to change the extension of your Excel file. Once the extension is changed, you open the file and make some modifications to an inner file and save it. It then removes the password from your Excel file.

Step 1. Change the extension of your Excel file to .zip by right-clicking on the file and selecting Rename.

Step 2. Open the file with WinRAR, head to xl > worksheets directory, right-click on any of the sheet and select Edit.

edit excel sheet

Step 3. Remove the code that starts with sheetProtection and save the changes.

remove protection code

Open the file in Excel and you will find it no longer prompts you to enter a password. Now you know how to crack Excel file password by simply changing the file extension.

Part 2. How to Crack Excel Password with Professional Excel Password Cracker

Although the methods described above will work most of the time, sometimes they may fail to deliver the results. In those cases, you are highly recommended to use a professional software to crack the password for your Excel files.

Excel Password Recovery is one of the software that helps you crack the password for your Excel file using various methods on your computer. It comes with the following features packed into it.

  • Quickly crack the opening password for your Excelfiles.
  • Multiple options to crack the password with high success rate.
  • Hardware utilization to speed-up the cracking process.
  • Supports Excel 2019/2016/2013/2010/2007/2003.
  • Safe and secure.

It only takes a few clicks in the software to crack the password and the following shows how it works.

Download SmartKey Excel Password Recovery:

Free Trial
Secure Download
  • Download, install, and launch the software on your computer. Click on Add and add your Excel files to the software.

    import file
  • Select an attack type from three attacks available on your screen.

    dictionary attack
  • Hit Start when you have selected an attack type. Within a few seconds, you will see the password for your file on your screen.

    recover password

If you have not yet found a way on how to crack Excel sheet password, the above guide has got multiple ways for you to do the task on your computer.

Download SmartKey Excel Password Recovery:

Free Trial Buy Now

Only $19.95

Secure Download
30 Days Money Back Guarantee
downloadDownload this article as :  
comments powered by Disqus

NEXT TOPICS
Online Password & Key

Crack and get back all your online webiste password such as facebook and twitter


Connect with SmartKey

Copyright©2007-2020 SmartKey Password Recovery. All rights Reserved.