Unprotect Excel Workbook

Updated on January 2, 2024
Article byJeevan A Y
Edited byNannila Jai Ratna
Reviewed byDheeraj Vaidya, CFA, FRM

Unprotect Workbook in Excel

Unprotecting a workbook in Excel helps us do changes. But, we need to protect workbook to prevent readers from tampering with the data;

There are two ways of protecting the workbook in Excel. In our earlier article, “Protect Workbook in Excel,” we have seen how to protect the workbook in those two ways. Below are the steps to protect and unprotect the workbook in Excel.

Unprotect-Workbook-in-Excel

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Unprotect Excel Workbook (wallstreetmojo.com)

Excel Workbook Protection at File Level

In this method, we are protecting the entire workbook from opening and editing the content of the workbook.

The option of “Protect Workbook” is a built-in tool in Excel. It is available under the “Review” tab in Excel.

Excel Protect Workbook 1

To protect the workbook, below are the steps.

  1. First, we must open the Excel workbook that we need to protect.

  2. Then, go to the “Review” tab and click on the “PROTECT WORKBOOK” option.

  3. Now, we can see the below option, where we need to enter a password to protect. In the below “Protect Structure and Windows” window, enter the password as per the choice.


    Excel Protect Workbook 1-1

  4. Next, click on “OK.” In the next window, we need to re-enter the same password we entered in the previous step.


    Excel Protect Workbook 1-2
    Click on “OK.” It will protect the workbook at the file level.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Excel Workbook Protection at Workbook Level

In the previous step, we have seen how to protect the workbook at the file level. In this method, we can preserve the workbook at the workbook level, which will prevent a user from opening it when you are not around with your computer.

Using this method, we restrict the user from peeping into the workbook. Follow the below steps to protect the workbook at the workbook level.

Step 1: First, go to the “File” option, which is the first in the ribbon.

Once we click on the “File” option, we may see the Protect Workbook option on the right-hand side, as shown in the below image.

Excel Protect Workbook 2

Step 2: Next, in the “Protect Workbook” option, click on the drop-down list in excel to see the option “Protect Workbook” in the list, and then, select “Encrypt with Password.”

Excel Protect Workbook 2-1

Step 3: Now, we will see the “Encrypt Document” window. Next, enter the password and then, click on the “OK” button.

Excel Protect Workbook 2-2

Step 4: Now, in the next window, we will see the window which asks us to re-enter the password we entered in the previous step.

Excel Protect Workbook 2-3

One thing is we need to remember the password that we have entered.

Once you have re-entered the password, save and close the workbook. All the changes that we made will apply to the workbook.

Next time when we need to open the workbook, it will ask us to enter the password.

Excel Protect Workbook 2-4

Unprotect Excel Workbook

Once the workbook is protected with a password, to unprotect it, we need to remember the exact password that we have entered while preserving the workbook. Follow the below steps to unprotect the protected workbook in Excel.

Step 1: First, open the desired workbook.

Step 2: Next, it will ask you to enter the password.

Method 1

Step 3: Then, enter the password that you had given while protecting it.

Method 1-1

Step 4: Now, click on “OK.” It will open the workbook.

Step 5: Next, to unprotect, click on the “File” tab. You will see the “Protect Workbook” option.

Method 1-2

As we can see just below the “Protect Workbook” option, it says, “A password is required to open this workbook.”

Step 6: Now, click on the drop-down list, and then, choose Encrypt with Password.”

Method 1-3

Step 7: Now, we will see the below window.

Method 1-5

Now, we can see the password with black dots, so to unprotect the workbook, delete the password and then, click on “OK.”

Method 1-6

The Excel workbook is unprotected and no longer requires a password to open it.

Things to Remember

  • Password is mandatory to open the workbook if it is protected with a password.
  • But for unprotecting, the workbook password is not required. We can delete the password and unprotect the workbook.
  • The “Protect Workbook” and “Protect Worksheet” are different from each other.

This article has been a guide to Unprotect Workbook in Excel. Here, we learn to unprotect the Excel workbook, methods, and downloadable Excel template. You may learn more about Excel from the following articles: –