top icon

Rated successfully!


You have already rated this article, please do not repeat scoring!

(6 Tips) How to Remove Password from Excel without/with Password

home_icon Created with Sketch. Home > Unlock Files and Windows > (6 Tips) How to Remove Password from Excel without/with Password
User Img
Francisco Spearman

August 20, 2019 (Updated: August 20, 2019锛

4 min read

0 Count

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.

Windows version

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”.

choose recover password

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.

choose attack type

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.

recover password

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.

unprotect excel sheet online

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.

encrypt with password

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.

choose remove restrictions

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.

all excel sheet

In about a minute, all editing restrictions will be removed and you’ll be able to edit the document however you want.

remove restrictions

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”.

change excel name to zip

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.

open xml with archive program

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.

delete protection tag

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”.

preview protect workbook

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.

Generally rated 4.5 (122 participated)

Black Friday Deals

Get iMyFone LOWEST price of the year! Win iPhone 12 and other gifts!

Enter Now >