How to Open Password Protected Excel File? Solved!

“How to open password protected Excel file? I have rarely used an Excel spreadsheet, and recently, my colleague shared a password-protected file, which he was also unable to access. Is there any technique that I can apply to view or open a locked Excel file without entering its password?”

If you intend to share your PDF, Word, Excel documents on the internet, it is vital to keep them encrypted. It is a handy practice to prevent irrelevant personnel from accessing the contents of the document. However, it could cause an issue for you, especially when you forget the password to open the password protected Excel file.

Still, there is no need to panic. There are a few methods you can apply to open password protected Excel file online for free. We will discuss all of them in this post.

• Method 1. Open Password Protected Excel File with PassFab for Excel
• Method 2. Open Password Protected Excel File by VBA Code
• Method 3. Open Password Protected Excel File Online
• Tips. Open Password Protected Excel File with Known Password

Method 1. Open Password Protected Excel File with PassFab for Excel

When you aim to remove Excel document encryption, it is better to use a reliable and trusted Excel password recovery, such as PassFab for Excel. The software works on all modern Windows versions, including Windows Server 2019/2016/2012/2011/2008.

Moreover, PassFab for Excel lets you open the password-protected Excel file at a quick rate. Additionally, it supports the .xls and .xlsx format of the worksheet. The tool doesn’t require a high-end PC to function. You can operate PassFab for Excel to open a password-protected document on a PC with 512MB RAM.

Here are the top features of PassFab for Excel:

• You can recover the lost password of an Excel workbook.
• It can remove the Read-Only protocol from the Excel file.
• After removing password protection, PassFab for Excel preserves the original data available on the worksheet.

Please follow the step-by-step guide on how to open a locked Excel file:

Step 1: Run PassFab for Excel

The first step is to download and install the software on your Windows PC. Once you do that, launch the tool by double-clicking on its icon.

Step 2: Upload the Excel file to the Interface

Click on the “+” button available on the interface to add the encrypted Excel file to start the process. Select the Excel file from the new dialogue box, as it will detect the password complexity instantly. After that, proceed to the next step.

Step 3: Choose Any Password Recovery Mode and Initiate Recovery Process

PassFab for Excel offers three different recovery modes:

• Dictionary Attack: If you know the type of password you have used before. Please put them in a text file, and the mode will find the correct one automatically.
• Brute Force with Mask Attack: When you only have a slight clue on the password, such as identifying the prefix or suffix.
• Brute Force Attack: You can apply this mode when you have no clue regarding the lost Excel password.

Simply select one of those modes, and click on Recover. The tool will display the password in a few minutes.

Lastly, enter the recovered password to access the Excel workbook!

Method 2. Open Password Protected Excel File by VBA Code

Microsoft has developed its own programming language, which the users can apply to MS Excel to manage data and spreadsheets more conveniently. The language is called VBA or Visual Basic for Applications.

The language is essential for users as it can assist in analyzing the data, forecasting, and budgeting quickly. Moreover, you can implement a specific VBA code to open a password protected Excel file.

The solution is as follows:

1. Open the password protected Excel file.
2. Press the Alt and F11 keys at the same time to open the VBA Editor.
3. From the toolbar, click on the Insert tab and select Module.
4. Enter the following VBA code to recover the password of the Excel file:
   Sub UnProtectWorkbook()
On Error GoTo ErrorOccured
Dim pwd1 As String, ShtName As String
pwd1 = InputBox("Please Enter the password")
If pwd1 = "" Then Exit Sub
ShtName = "Workbook as a whole"
ActiveWorkbook.Unprotect Password:=pwd1
MsgBox “The workbook’s structure has been Unprotected.”
Exit Sub
Error occurred:
MsgBox “Workbook could not be UnProtected - Password Incorrect”
Exit Sub
End Sub
   
   
5. Press the F5 key from the keyboard to execute the VBA code. A new pop-up window will appear. Simply click on OK to cancel the password.

Method 3. Open Password Protected Excel File Online

Some users do not prefer installing third-party tools to remove Excel file encryption. Moreover, they might find applying the VBA code a bit too complicated. For such users, the best option is to access online tools such as LostMyPass to open password protected Excel files for free.

The platform is easy to use and accessible on all devices. Furthermore, it supports both .xls and .xlsx file formats. However, you will be exposing your data on the internet, which could be a bit risky.

However, you can only decrypt an Excel file under 100MB for free on LostMyPass. Furthermore, the efficiency is only 22%, which is low compared to other methods like PassFab for Excel.

You can learn how to open a locked Excel file using the online LostMyPass tool by following the steps mentioned below:

1. Access LostMyPass from your system’s browser.
2. Hit the Click Here button to upload the protected Excel file.
3. The tool will figure out the encryption by running through its database of 3 million of the most popular passwords.
4. Note down the password. That’s it!

Tips. Open Password Protected Excel File with Known Password

If you happen to know the password, then it will save you a significant amount of time. There will remain no need for you to apply any of the methods mentioned above. The steps are as follows:

1. Open the encrypted Excel file on your Windows PC.
2. A dialogue box will pop up, asking you to enter the correct password to access the file.
3. Type the password and click on OK.
4. That’s it!

Conclusion:

Now you know all about how to open a protected Excel sheet. We have discussed all the techniques that are simple to apply without acquiring any technical knowledge. You can apply each one of them without any issue to get the result quickly.

Still, it is vital to remember the password to your encrypted Excel file. You can write them down in a notebook or a separate text file. However, if you somehow manage to forget it, then you know all the tricks in the book to open password protected Excel file.