Excel spreadsheets are perfect for organizing data and in many cases this data is often sensitive in nature. This is the primary reason the password protection feature in Excel can be absolutely crucial.
There are 2 primary ways you can apply to protect an Excel document. You can set an open password meant to prevent someone from opening the document or you can set a modify password that protects the workbook and worksheets, allowing someone to open the document but restricting editing.
Whatever method of protection you choose, it is absolutely important to remember the password. But what if you set the password and forgot it or you have an encrypted Excel document and don’t have the password? Whatever the case, this article will show you various ways to remove password from Excel excel 2019/2016/2013/2010/2007/2003 whether you have the password or not.
Case 1. How to Remove Password from Excel to Open
In this first section, we are going to deal with the opening password, the password you have to enter to gain access to the document.
1.1 Remove Password from Excel to Open without Password
The following are some of the solutions to try if you have forgotten the open password:
Way 1: Using Passper Excel Password Remover
If you have forgotten the opening password for an Excel document, the only way to get it back would be to use an Excel password remover program. Passper Excel Password Remover presents the most effective password remover tool that is designed to help you find the opening password for any Excel document. One of the program’s greatest strengths is that it has the highest rates of recovery for any program. This nearly perfect recovery rate can be attributed to the fact that it utilizes the most advanced technology and 4 different attack modes to recover the password.
Most shareware or online tools only possess the function of removing password to open the locked Excel while Passper Excel Password Remover has the functions to remove password to open and password to modify with 100% password removing rate.
Here’s how to use Passper Excel Password Remover to remove password from Excel file to open:
Step 1: Download Passper and install it on your computer. Launch the program and in the main window click on “Recover Passwords”.
Step 2: Click “Add” to import the password protected Excel document into the program. Once the program has been successfully added, select an attack mode to help you remove the password. Different attack modes are useful for different types of password and the one you choose will depend on the complexity of the password.
Step 3: Once you have selected the attack mode to use, Passper will immediately begin recovering the password. The process may take some time depending on the attack mode selected. When the password has been recovered, it will be displayed on the screen.
You can now use it to remove password protection from Excel document.
Way 2. Using an Online Tool
There are some online tools that can also help you remove password from Excel to open. These allow you to remove the password without having to install any software on your device. Many of them primarily use the brute force method of recovery which means that the recovery rate may not be as high as with Passper Excel Password Remover and the process may take a long time.
Cons of Using an Online Tool:
Apart from a lower recovery rate, online tools also come with some significant disadvantages. These include the following:
- You may be exposing your Excel document to online platforms which can make them more vulnerable from hackers, scammers and other groups.
- This process relies on your connection to the internet. Interrupted internet connectivity means that the password recovery process will also be interrupted.
1.2 How to Remove Protection from Excel to Open with Password
When you already know the password, removing the opening password on your Excel document is a very simple process. Follow these simple steps to do it:
Step 1: Open the protected Excel document and enter the password when prompted.
Step 2: Now go to File > Info and then click on “Protect Workbook/Document”.
Step 3: Click on the “Encrypt with Password” option on this window and a dialogue box with the password will appear.
Step 4: Remove the password and then click “OK”. Save the document and the password will be essentially removed from the document.
Cast 2: How to Remove Password from Excel to Modify
The method you choose to remove a modify password from your Excel document will depend on whether you know the password or not. Let’s look at each scenario.
2.1 Remove Excel Password to Modify without Password
If you don’t know the password that is used to restrict editing on the document, use one of the two ways below to remove the modify password.
Way 1: Using Passper Excel Password Remover
Apart from recovering the opening password, Passper Excel Password Remover can be used to remove restrictions from the Excel document and the process is very simple. Just follow these steps:
Step 1: Open Passper on your computer and select “Remove Restrictions” from the main window.
Step 2: Click on “Add” and import the document into the program. Once the document is added into the program, click “Remove” and the program will begin removing any editing restrictions on the document.
In about a minute, all editing restrictions will be removed and you’ll be able to edit the document however you want.
Way 2: By Changing the File Extension
If you don’t know the modify password on an Excel sheet/workbook, you may be able to remove the restriction by changing the file extension. Follow these simple steps to do it:
Step 1: Locate the restricted document on your computer and then change the file extension from .xlsx to .zip. If you don’t see the file extension on the document, go to Control Panel > Folder Options > View Tab and uncheck “Hide Extensions from Known File Type”.
Step 2: Open the Zip file and locate the .xml file. Open it in Notepad and look for the tag beginning with <sheetProtection password=…/> and delete it.
Step 3: Save the XML file and then put it back in the .zip file. Change the extension back to .zip and the editing restrictions should be removed.
2.2 Remove Password from Excel to Modify with Known Password
If on the other hand you already know the password used to restrict editing, you can follow these simple steps to remove the password:
Step 1: Open the protected workbook on your computer and then click on “Review > Protect Workbook”.
Step 2: Enter the password when prompted and then click “OK”.
The password will be removed from the protected workbook, allowing you to edit the document any way you want.
Losing the password to an important Excel document can mean you may not be able to open or modify the document. The solutions to remove password from Excel are laid out in this article to help regain access of the document thereby preventing you from choosing to create a whole new document. Share your thoughts on this topic or any other in the comments section below.