Unprotect Workbook in Excel
Once the report is finalized, we will share the workbook with the concerned team or personnel. Often times, we just need them to read the report without doing any modification to the existing report. So, in order to prevent readers from tampering with the data, we should allow them to alter anything in the workbook. There are two ways of protecting the workbook in excel, and 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 in brief.
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. This is available under the REVIEW tab in excel.
To protect the workbook, below are the steps.
Step 1: First, we need to open the excel workbook that we need to protect.
Step 2: Then go to the REVIEW tab and click on the PROTECT WORKBOOK option.
Step 3: Now, we can see the below option, which asks for a password to be entered to protect. In the below Protect Structure and Windows window, enter the password as per our choice.
Step 4: Click on OK. In the next window, we need to re-enter the same password as we have entered in the previous step.
Click on Ok. It will protect the workbook at the file level.
Excel Workbook Protection at Workbook Level
We have seen how to protect the workbook at the file level in the previous step. In this method, we can protect the workbook at the workbook level, which will prevent a user from opening it when you are not around with your computer.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
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: Go to the File option, which is the first one in the ribbon.
Once we click on the FILE option, we will see the Protect Workbook option on the right-hand side, as shown in the below image.
Step 2: In the Protect Workbook option, click on the drop-down list in excel to see the options of “Protect Workbook” in the list, select “Encrypt with Password.”
Step 3: Now, we will see the “Encrypt Document” window. In this, enter the password as per our wish and click on the OK button.
Step 4: Now, in the next window, we will see the window which asks us to re-enter the password as we entered in the previous step.
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.
Unprotect Excel Workbook
Once the workbook is protected with a password, to unprotect, we need to remember the exact password that we have entered while protecting the workbook. Follow the below steps to unprotect the protected workbook in excel.
Step 1: Open the desired workbook.
Step 2: While opening, it will ask you to enter the password.
Step 3: Enter the password that you had given while protecting it.
Step 4: Click on OK. It will open the workbook.
Step 5: To unprotect, click on FILE. You will see the “Protect Workbook” option.
As we can see just below the “Protect Workbook” option, it says, “A Password is required to open this workbook.”
Step 6: Click on the drop-down list, and choose “Encrypt with Password.”
Step 7: Now, we will see the below window.
We can see the password with black dots, so to unprotect the workbook, delete the password and click on OK.
Now the excel workbook is unprotected and no longer has it required the 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 just delete the password and unprotect the workbook.
- Protect Workbook and Protect Worksheet; both are different from each other.
This has been a guide to Unprotect Workbook in Excel. Here we learn how to unprotect the excel workbook along with methods and downloadable excel template. You may learn more about excel from the following articles –