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 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 PROTECT WORKBOOK option.
Step 3: Now we can see 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 File option which is the first one in the ribbon.
Once we click on FILE option we will see 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 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 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 excel workbook along with methods and downloadable excel template. You may learn more about excel from the following articles –