5 Ways To Open Password Protected Excel File 2022

0

5 Ways To Open Password Protected Excel File 2022 – Are you currently having problems with your Excel files? Your Excel file cannot be opened because it is locked by a password. In this article, we will provide a tutorial on how to easily open a locked Excel password.

5 Ways To Open Password Protected Excel File
5 Ways To Open Password Protected Excel File

How To Open Password Protected Excel File 2022

Microsoft Excel is an application that is used to create financial reports and so on. However, sometimes Excel is locked, this is caused by the sender forgetting to send the password or deliberately not being notified.

Read more:

Even though Excel files are very important for a job or task. There are also secret Excel files that only certain people can open and know.

Therefore, if you are experiencing problems like this, we will provide a solution for how to easily open an Excel password. Read on for the review in the article below.

Open Password Protected Excel File

There are several ways that you can use to open a forgotten Excel password that makes it locked. Some of the methods below have previously been tried and worked successfully.

1. Opening Excel Password Without Application

Opening Excel Password Without Application
Opening Excel Password Without Application

How to open a forgotten excel password:

  1. The first step is for you to open an Excel file that is locked or protected by a password.
  2. if you have, then you press the Alt + F11 key combination on the keyboard, wait a while Microsoft Visual Basic will automatically appear.
  3. If it appears, please select the Insert menu  and select Module  to be able to open the module menu. 
  4. Later on your computer screen, the module menu will appear.
  5. Next, please input and copy the following code into the module menu.

Here’s the source code that you have to copy

Sub InternalPasswords()
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 NextFor 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
ActiveWorkbook.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)
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 ActiveWorkbook.ProtectStructure = False Then
If ActiveWorkbook.ProtectWindows = False Then
If ActiveSheet.ProtectContents = False Then
Exit Sub
End If
End If
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

If the text above has been copied, then paste it into the module menu. then follow the steps below.

  1. Next, you select which sheet you want to open in the Excel file and then select ” Run Macro ” which is green
  2. After the “ Macro ” window pops up, click “ Run ” to start cracking the Excel password on your computer.
  3. Now you just have to wait for the process to finish.
  4. The length of time depends on how much data and size the Excel file has
  5. After the process is complete, you can open or change the Excel file data freely because the protection has been lost.

2. Unlocking Protected Excel File Password

Unlocking Protected Excel File Password
Unlocking Protected Excel File Password

The solution for how to solve an Excel file that cannot be opened is to bring up the password again. After we know the password, we can immediately open it by looking in the ” Unprotect ” menu.

In the following, you can learn how to display the password embedded in an Excel file with a series of scripts and codes.

How to open a locked excel password:

  1. The first step is to open your Excel file.
  2. Once open, press the ” ALT + F11″ key to bring up ” Microsoft Virtual Basic “
  3. Next, enter the script by clicking ” Insert ” then after that select ” Module “
  4. After the module form appears, enter the script below into the form

Here’s the source code that you have to copy

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
  1. The next step is to select which sheet you want to open and click ” F5 ” to bring up the ” Run Macro ” dialog box.
  2. After the ” Run Macro ” window appears, click the ” Run ” option to start the process of bringing up the password
  3. If so, close the ” Microsoft Virtual Basic ” window then select ” Review ” then click ” Unprotect Password”
  4. After that enter the password and click “OK”. Now you can get full access to the data in the file

3. Opening Excel Online Password

Opening Excel Online Password
Opening Excel Online Password

When you want to open an Excel password, we will give you another option to open a protected Excel file, namely by using the excel.xartifex.com website. Through this website, you will be able to upload protected Excel files online.

How to open an excel password online:

  1. First, open the address  excel.xartivex.com  using a PC or smartphone browser.
  2. Then click ” Selected File ” then look for the protected Excel file then click ” Open “
  3. Wait a few moments until the Excel file has been successfully opened by the system. This website has been tested to open Excel files that are protected with a fairly complex password
  4. If Excel is already open, you can re-download the file and then edit it freely as needed

4. Remove Excel Password With Google Drive

Remove Excel Password With Google Drive
Remove Excel Password With Google Drive

You can follow this tutorial with the help of the Google Drive application, the method is quite easy to do. Here’s how to open an excel password with the application:

  1. The first step is to open Google Drive through the application/browser. You need login access if you already have an account, if not then you have to create an account first
  2. Then click “ + New ” to add a protected Excel file. Then click ” File Upload”, then click the Excel file then click ” Open “
  3. if it has been uploaded, double click on the Excel file to be able to open it. Then click the ” Open with ” menu then click ” Google Sheets “
  4. The file will open in the form of Google Sheets and the protection will automatically disappear. To download it again, you just click ” File ” then ” Download As ” then select ” Microsoft Excel (.xlsx)”
  5. Give a new name that is different from the original file then clicks ” Save ” to download it.

5. Opening Excel Password With ZIP

Opening Excel Password With ZIP
Opening Excel Password With ZIP

This method can be used to unlock a forgotten Excel password, but you must have the WinRAR application or a 7-zip application that you can download for free.

How to open an Excel password with ZIP:

  1. First, open an Excel file that forgot the password so that it is locked.
  2. Then click View on the menu then put a checkmark on the File Name Extension section.
  3. In the Excel file format change from  .xlsx  to  .zip  then click  Enter and select  Yes.
  4. After that open the Excel file with the ZIP application and change the format of your filename from .xml to .txt
  5. Open the file with the notepad application and find the  <sheetProtection code then delete the code until the /> limit then click Ctrl + S.
  6. If a notification appears, click  Yes.
  7. Then return the Excel file format to .xml then close the ZIP application and change the format to .xlsx as before.
  8. Finished.

Read more:

Conclusion:

There on about 5 ways to open a password protected Excel file. You can choose which methods and steps you think are easiest to apply.

Don’t forget to bookmark and always visit every day Technowizah.com because you can find here the latest Tech Computer Android games How-to Guide Tips&Tricks Software Review etc, Which we update every day.

Previous articleWhat is the difference between Unix and Linux 2022
Next article5 Ways To Fix Windows Script Host Access Is Disabled 2022
I'm Akshara Singh, from Tamil Nadu (India) I have been Running this Blog since 2016 with my full effort to Help users in the Tech field and clear doubt, and provide advanced guides in simple methods.

LEAVE A REPLY

Please enter your comment!
Please enter your name here