How to Remove Password from Excel File

People often use a password to protect their Excel files and somehow it is easy and safe because Excel files are broadly used to save financial data and information of individuals or companies. But what will happen if you lose or forget the password for that Excel file? It will be quite bothersome as you will also lose the data that is inside that Excel workbook. It is also troublesome when you always have to enter the password when you open the file or you have to send someone Excel file after removing the password. So you need to know some Excel password remove techniques. In this article you will get to know how to remove the password from Excel. You will be guided to remove password for different versions of Excel.

Part 1: How to Remove Password from Excel When You Know It

If you have an Excel document with password protection it is annoying to always enter the exact password for that file. It is also annoying because if you more than Excel files with password protection you will surely mix-up their passwords. So you had to save the passwords for each file in a separate file and keep track if you change the password. Another case is that you have to send a password protected Excel file to someone and you have to remove the password before sending it to that individual.

Below are steps that you can take for Excel remove password protection. 2 Methods for different version of Microsoft Excel are explained so if you have an older version of Excel document, you can easily remove the password from the file.

Method 1. Remove Excel Password with "Save As" Feature

This method will guide you to remove password for Excel when the password is known. It is an easy way. Follow the steps and your Excel document password protection will be removed.

Step 1: In this method first open your Excel file which is password protected.

Step 2: A dialogue box will open asking to enter password. Enter the Password and click OK.

open password

Step 3: Now click on File > Save As and select location where you want to save the Excel file after removing password. If you have an older version of Microsoft Excel, click on Microsoft Office and then on Save As.

save as

Step 4: Before saving the file click on Tools.

click tools

Step 5: Now in the drop down menu click on General Options.

click general options

Step 6: A dialogue box will appear. There you have to clear the existing password in Password to open text box and click OK.

remove pasword to open

Step 7: Now save the file and you will be able to open the file without entering password.

Method 2. Remove Excel Password with "Info" Feature

This is another method when you know the password but do not know how to remove password for Excel? Follow the steps and remove the password security easily.

Step 1: First open the Excel file whose password you want to remove. When you open the file you had to enter the Password.

open password

Step 2: Click on File and then click on Info.

click info

Step 3: Now click on Protect Workbook and in the drop down menu click Encrypt with Password. In older versions you will click on Protect Document > Encrypt with Password.

click encrypt with password

Step 4: In the dialogue box erase the Password and click OK.

click erase password

Step 5: Save the file and your Excel file password protection will be removed.

Part 2: How to Remove Excel Password When You Forgot It

So have you forgot the password for your Excel document and want to remove the password so you can access the data in the file. How to remove password from Excel? It is easy. PassFab for Excel is the tool you can use to tackle this frustrating situation. It is the best software to recover or remove the Excel password when you have forgotten or lost it. It is the quickest and most efficient password recovery software for Excel.

Key Features:

  • You can recover Excel workbook open passwords.
  • You can remove Excel workbook and worksheet protection passwords.
  • You can get speed Excel password crack with multicore CPU and GPU acceleration.
  • It supports all the versions for example Excel 2019, 2016, 2013, 2010, 2007 and lower.

Option 1. How to Remove Excel Password to Modify

Step 1. Run this software and choose "Remove Excel Restriction Password" feature.

remove excel password

Step 2. Import the Excel file that is able to open but unable to modify any content. Then click "Remove" button.

remove excel password

Step 3. Within seconds, you will get rid of the password easily and see the copied Excel file without any password in your computer.

remove excel password

Option 2. How to Remove Excel Password to Open

So this software is all in one package for your problems. It provides 3 different attack options which are Brute-force with Mask Attack, Brute-force Attack, and Dictionary Attack. Each attack option has its own parameters and password recovering time. Following is the method to remove the password when you don’t seem to remember it using this Excel password recovery tool.

Step 1: Launch the Excel password recovery tool, you will see two functions. Choose "Recover Excel Open Password" and continue.

passfab for excel

Step 2: Add the Excel document and select any decryption method. You can customize the Settings for the selected method.

import

Step 3: Click on Start and the software will initiate the process to decrypt the password for the Excel document. It will take time to wait until the process is completed. The duration of the decryption depends on the method selected.

start recovering

Step 4: When the process is completed, the password recovered will be displayed in the dialogue box.

password was found

Finally, in order to open the Excel file withut typing password again, you need to follow the methods in Part 1. Here is a video tutorial about how to remove Excel password:

Summary

So you have now had the full knowledge on how to remove password from Excel whether you know the password for the document or you have forgotten or lost it. These methods are easy and simple and you can remove the password without any problem. Also, the PassFab for Excel is the best choice for people who have little knowledge of computer. It has user interactive interface and is easy to use.

Updated on / Posted by Shirley Howard to Excel Tips / Follow @Shirley Howard

Comment

Product-related questions? Speak directly to our Support Team >>