3 Methods to Remove Password from Excel File When Opening File

author_icon Ronnie Barnes time_icon Last updated: Jul 22, 2019 04:32 pm tips_icon Excel

You might have added password to your Excel file to protect the file against unauthorized access or modification. If by chance, at a certain point of time, you forgot this password, you would need to find out ways to remove the password so that you can have access to open or edit your Excel file. Check out the different steps to remove password from excel file when opening file.

1. Remove Password from Excel When Opening File with Password

When trying to open an encrypted Excel file, you will be prompted to enter the opening password. If you know what the password is, find out how to remove password from an Excel file below.

Step 1. Open "Menu" by pressing the Windows Button. Click on Microsoft Excel to launch the application.

Step 2. Once the Excel application opens, click on "File" from the Menu bar. Click on "Info" and then "Permissions".

Step 3.Click on "Encrypt with Password" and the entry box where you can enter your password will pop up.

remove password from excel with password

Step 4. Leave the password into the entry box empty and click "Ok", the password will soon be removed.

Step 5. Click on "Save" so that the changes can take effect.

Close the Excel file and open it again. It will open immediately without asking you to enter your password.

2. Remove Password from Excel When Opening File without Password

2.1 Using Excel Password Remover/Recovery Software

Passper for Excel, a professional Microsoft Excel Password Recovery tool aims to decrypte forgotten passwords for Excel Files. Here are the main reasons why Passper for Excel is one of the most appropriate choices when it comes to recovering lost Excel passaword.

  • It allows you to recover the lost or forgotten opening password for Excel files.

  • It is 100% effective to removing restrictions for password-protected Excel workbook or worksheet for you to edit, print, copy, etc.

  • The major benefit of using this tool is that it does not damage the Excel file and the file remains as it was initially.

  • It can recover passwords for Excel files .xls and .xlsx created by Excel versions from 1997 to 2019.

  • This tool also allows you to pause the password recovery process and resume later.

  • The tool is compatible with all versions of Windows operating system.

Free Downloadfor Win 10/8/7/XP/Vista

How to Recover Opening Password for Excel File with Passper for Excel

Step 1Launch Passper for Excel and click on "Recover Passwords".

choose recover passwords  

Step 2Click on the "+" icon to import the Excel file you want to unlock the opening password. There are four attack modes, and each of them is explained below.

import excel document  

Dictionary Attack: This attack mode imports the dictionary file from the password dictionary for Passper for Excel. And this program will scan through the dictionary and locate your password.

Combination Attack: This attack mode finds your password by customizing the character settings and combining random characters that you choose.

Mask Attack: The mask attack mode requires knowing some parameters of your password such as length and the combination of alphabets and special characters in the password. This attack type will shortly shorts the recovery process.

Brute Force Attack: This mode will explore every possible character to recover your Excel password. Generally, it will take the longest recovery time.

Step 3After the recovery progress is finished, the opening password for the encrypted Excel document will be displayed on the interface. You can directly copy the password to open the Excel file.

unprotect excel 2016  

2.2 Using an Online Tool to Recover Excel Opening Password

To remove password protection from Excel, online tools can come in handy as you will not have to worry about downloading and installing any 3rd-party tools on your computer. You only have to visit a website and remove password from your Excel file directly on the site.

  • Visit the website of online Excel password remover tool and upload the Excel file.

  • After uploading, the website will commence the process of recovering your password.

  • Wait for a few minutes, and the password that is recovered will be displayed on the screen.

  • Enter the cracked password into your locked Excel file to unlock it. Once you have opened the Excel file, disable the password from the software.

excel file password remover online

   This method, however, has its disadvantages which are listed below:

  • Using an online platform to unlock your Excel files makes the content of the file vulnerable to third-parties, and anyone can use the content for nefarious activities.

  • Unstable internet connection will interrupt the smooth running of the process.

3. Remove 'Password to Modify' from Excel When Opening File without Password

Not all the time are passwords meant for locking Excel files. Sometimes the passwords are meant to prevent anybody from editing or modifying the Excel workbook or Excel worksheet. If you have forgotten the password you used for this restriction, Passper Excel Password Recovery tool can also help you to fix this issue so that you will be able to make changes to your workbook once again. Follow the steps below:

Free Downloadfor Win 10/8/7/XP/Vista

Step 1Install Passper for Excel. And click on "Remove Restrictions" option.

choose remove restrictions  

Step 2Click on "Select a file", You will be granted access to the files on your computer so you can select the Excel file you want to remove restrictions.

add excel worksheet  

Step 3 Tap on "Remove", and the restrictions will be removed permanently. Then you will be able to modify your Excel file again.

unprotect excel sheet 2016  


Passper for Excel is a very useful tool used to fix any issue that has to do with password recovery of Excel files. Download the software on your computer today to enjoy its numerous benefits. It can work with any versions of Excel.


By Ronnie Barnes to Excel

Posted on Apr 22, 2019 ( Updated: Jul 22, 2019 )

Ronnie Barnes, a blogger with more than 5-year experience in writing tips about password recovery for Windows and office files.