Do you have an Excel workbook that is password protected? While a password can be very useful in protecting the content on the workbook, it can be quite problematic when you need to enter the password every time you want to open the document. It can even be more of a problem when you forget the password because then, you are unable to access the document.

In this article we are going to share with you how to open a password protected Excel file whether you know the password or not.

1. How to Open Password Protected Excel File without Password

Let’s begin with the more complex of the two scenarios. If you have an Excel document that is password protected and you’ve forgotten the password, the following solutions will be useful to you.

1.1 Open Password Protected Excel File with Passper for Excel

The best way to open password protected Excel file without the password is to remove the password using Passper for Excel. This tool is the most effective way to remove any Excel password regardless of complexity or length. It utilizes the most advanced technology and 4 different attack modes to help you remove the password. As we shall see shortly, it is also very easy to use with an interface that is very simple to understand.

  • Password to open: Simply recover the Excel password to open however long and complex the password is.
  • Password to modify: Remove Excel password to modify with 100% removal rate in 3 seconds.

Windows version

To use Passper for Excel to remove Excel password to open, download and install the program on to your computer and then follow these very simple steps:

Step 1: Launch Passper for Excel and then select “Recover Passwords”. Click on “Add” to import the protected document into the program.

select recover passwords

Step 2: In the next window, select the preferred attack mode to use for the recovery of the password. The attack mode you choose will depend on the complexity of the password and how much you know about the password.

choose attack mode

Step 3: Passper will begin recovering the password immediately after you’ve selected the attack mode. When the process is complete, the password will be displayed on the next window. You can use it to open the document.

recover opening password

1.2 Open Password Protected Excel File Online

If you would rather not use a program to remove the password, there are online tools that can help you do that. These tools are not as effective as Passper and there is significant risk when uploading documents online, but they can be useful when you need a quick solution. Here’s how they work:

Step 1: Open on any browser.

Step 2: Drag and drop the Excel file into the main page. You can also click on “Click Here” to browse for the file and add it to the page.

Step 3: The tool will begin the recovery process as soon as the document has been uploaded. All you have to do is, wait for the process to be completed.

Step 4: The tool will display the recovered password. You can then copy it and use it to open the password protected Excel file.


2. How to Open Password Protected Excel File with Known Password

Opening a password protected Excel document with the known password is relatively simple; just open the document and then enter the password in the provided dialogue box:

Step 1: Open the protected Excel document. You can do that by double-clicking on the Excel file.

Step 2: When the dialogue box appears requesting the password, enter the password and then click “OK” to unlock the document.

open password protected excel without password

Now you can easily change or remove the password if you want to.

Tip: Unprotect Password Protected Excel Sheet to Modify 

You may also have an Excel document that restricts modification. In this case, Passper for Excel can help you remove the restriction and make the document editable. Here’s how to do it:

Windows version

Step 1: Open Passper for Excel on your computer and in the main window, select “Remove Restrictions”. Click on “Add” to import the document into the program.

select remove restrictions

Step 2: Once the document has been added, simply click on “Remove” and Passper for Excel will begin removing all restrictions placed on the document. In a few seconds all restrictions will be removed and you can easily open the document.

remove restriction from excel

Password protection on Excel documents is an easy way to protect the data on it from unauthorized users. You now have various solutions to open password protected Excel file whether you have the password or not. Share your thoughts with us on this topic or other similar topics in the comments section below.