Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Decrypt Excel File Without Password (2 Easy Ways)

If you are stuck with an Excel file that is password protected and you don’t know the password then this article will be beneficial to you. The objective of this article is to explain how to decrypt Excel file without a password.


Download Practice Workbook

You can download the practice workbook from here.


2 Easy Ways to Decrypt Excel File Without Password

Here, I have taken the following Excel sheet as my dataset. It contains a sales overview.

Dataset to Decrypt Excel File Without Password

If I try to edit something in this Excel sheet it shows a Warning Box like the one you are seeing in the following image.

Warning Box When you try to Decrypt Excel File Without Password

To check if the Excel sheet is protected, go to the Review tab from Ribbon. Then in the Protect group, you will see that the sheet is protected.

If you click on Unprotect Sheet you will see the following dialog box will appear. You will need to insert a password here to decrypt the Excel file. In this article, I will show you how you can decrypt Excel file without password in 2 different ways.


1. Use ZIP Extension to Decrypt Excel File Without Password

For this method, I have taken the following Excel sheet which is password protected. I will show you how you can decrypt Excel file without password by using the ZIP extension.

Use ZIP Extenxion to Decrypt Excel File Without Password

Let’s see the steps.

Steps:

  • In the following image, you can see that the file extension is not showing.

  • To make the file extension visible, go to the View tab.
  • After that, check the File name extensions option.

  • Next, change the file extension to zip.
  • Then, press Enter.

Use ZIP Extenxion to Decrypt Excel File Without Password

  • Consequently, a warning box will appear asking if you are sure about it.
  • Next, select Yes.

Use ZIP Extenxion to Decrypt Excel File Without Password

  • After that, you will see that you have changed the file extension.

  • Next, select the file.
  • Then, right-click on it.
  • Further, select Extract to Decrypting Excel File.

Extracting Zip File to Decrypt Excel File without Password

  • Afterward, a new folder will be created.
  • Open that folder.

  • After that, open the folder named xl.

Opening xl Folder to Decrypt Excel File withour Password

  • Then, open the folder named worksheets.

Opening Worksheets folder to Decrypt Excel File without Password

  • Here, you will see all the worksheets of that Excel file. I want to remove protection from sheet3.

  • Next, select sheet3.
  • Then, right-click on sheet3.
  • Select Open with.
  • After that, select WordPad.

  • Next, in that document find the highlighted part in the following image.
  • Then. delete this part.
  • Afterward, press Ctrl + S from your keyboard to save it.

Removing Protection from Sheet to Decrypt Excel File without Password

  • Now, go back and select the following folders and files.
  • Afterward, right-click on those selected files.
  • Select Send to.
  • Then, select the Compressed (zipped) folder.

  • After that, name the file as you want.

  • Now, you will see that you have got your zipped file.

  • Next, change the extension of the file to xlsm.
  • Then, press Enter.

Changing File Extension to xlsm again to Decrypt Excel file without Password

  • Consequently, a warning box will appear.
  • Select Yes.

  • Finally, you will get your desired Excel file.
  • After that, open that file to check if the file is decrypted.

  • In the following picture, you can see that you have decrypted the Excel file without a password.


2. Employ Macros to Decrypt Excel File Without Password

Here, I will show you how you can employ Macros to decrypt Excel file without password. For this section, I have taken the following dataset. This sheet is protected with a password. Now, I will decrypt it without a password.

Employ Macros to Decrypt Excel File Without Password

Let me show you how you can do that.

Steps:

  • Firstly, go to the Developer tab.
  • Secondly, select Visual Basic.

Opening Visual Basic Editor Window to Decrypt Excel File without Password

  • Thirdly, the Visual Basic editor window will open.
  • Select Insert tab.
  • Then, select Module.

Inserting Module to Decrypt Excel File without Password

  • Consequently, a Module will open.
  • After that, write the following code in that selected Module.
Sub Decrypt_File()
Dim p As Integer, q As Integer, r As Integer
Dim a As Integer, b As Integer, c As Integer
Dim p1 As Integer, p2 As Integer, p3 As Integer
Dim p4 As Integer, p5 As Integer, p6 As Integer
On Error Resume Next
For p = 65 To 66: For q = 65 To 66: For r = 65 To 66
For a = 65 To 66: For b = 65 To 66: For p1 = 65 To 66
For p2 = 65 To 66: For p3 = 65 To 66: For p4 = 65 To 66
For p5 = 65 To 66: For p6 = 65 To 66: For c = 32 To 126
ActiveSheet.Unprotect Chr(p) & Chr(q) & Chr(r) & Chr(a) & Chr(b) _
& Chr(p1) & Chr(p2) & Chr(p3) & Chr(p4) & Chr(p5) & Chr(p6) & Chr(c)
If ActiveSheet.ProtectContents = False Then
MsgBox "Done!"
Exit Sub
End If
Next: Next: Next: Next: Next: Next:
Next: Next: Next: Next: Next: Next:
End Sub

VBA Code to Decrypt Excel File without Password

🔎 How Does the Code Work?

  • Here, I created a Sub Procedure named Decrypt_File.
  • Then, I declared 12 variables as Integer.
  • Next, I used 12 For Next loop to go through the characters.
  • Afterward, I used ActiveSheet.Unprotect method to remove the protection from the active sheet.
  • Then, I used the Chr function to get the characters equivalent to the ASCII code.
  • Next, I used ActiveSheet.ProtectContents property to check if the worksheet is still protected or not. If it is False then a message box will appear showing “Done!”.
  • Further, I used Exit Sub to exit the Sub Procedure.
  • Then, I ended the IF Statement.
  • Finally, I ended the Sub procedure.
  • Next, Save the code and go back to your worksheet.

Saving Code to Decrypt Excel File without Password

  • Afterward, go to the Developer tab again.
  • Then, select Macros.

Running Macros to Decrypt Excel File Without Password

  • Consequently, the Macro dialog box will appear.
  • Then, select Decrypt_File as the Macro name.
  • Next, select Run.

Macro Dialog Box to Decrypt Excel File without Password

  • After a while, a message box will appear.
  • Then, select OK.

  • Finally, the protection will be removed from the Excel sheet.
  • To check that, I will try editing the sheet.
  • First, select the range where you want to add Fill Color.
  • Then, go to the Home tab.
  • After that, click on the drop-down option for Fill Color.

  • Then, select the color you want.

  • Finally, you can see that a Fill Color is added to the selected range. That means you have decrypted the file without a password.


How to Decrypt Excel File with Password

In this section, I will show you how you can decrypt Excel file with password and then remove the password protection from the file. Let’s see how you can do that.

Steps:

  • To begin with, you will see a dialog box appear when you open the file.
  • Then, write the password in the dialog box.
  • After that, press OK.

How to Decrypt Excel File with Password

  • Consequently, your Excel file will be decrypted.
  • Next, go to the File tab.

  • Afterward, select Info.

  • After that, a dialog box will appear.
  • Clear the password from here.
  • Then, select OK.

  • Finally, you will see that you have removed the protection from the Excel file.

Read More: How to Remove Encryption from Excel (2 Methods)


💬Things to Remember

  • You have to remember that Method 2 is time-consuming. If you want to remove protection from multiple sheets then you will have to run the code from each sheet individually. And, it takes time to run the code.

Practice Section

Here, I have provided a practice sheet for you to practice how to decrypt Excel file with password.

Practice Sheet for How to Decrypt Excel File without Password


Conclusion

So, you have reached the end of my article. Here, I tried to explain how to decrypt Excel file without password in 2 different ways. I hope this article was clear to you. For more articles stay connected with ExcelDemy. If you have any questions, feel free to let me know in the comment section below.


Related Articles

Mashhura Jahan

Mashhura Jahan

Hey! Welcome to my profile. Right now, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo