If you have ever used an Excel Workbook, you may already know that one Workbook can store a lot of information. Inside one workbook, you can have numerous worksheets with related information. This makes Excel the perfect tool to track data which is why it is sometimes used to track important information like sales and expenditures or the performance of an advertising campaign. Most of this information can be important enough to warrant a password, which is why password-protection is one of the most important features in a workbook.
That said, sometimes you can be locked out of a protected workbook because you forgot the password or lost it. If this is the situation you find yourself in, worry not. This article will share with you how to unprotect Excel workbook in simple steps.
1. What is Excel Workbook?
Before we get to the processes that can help you unprotect a workbook, it is important to understand what a workbook is since most people often confuse them with worksheets.
To be clear, a workbook is a collection of more than one spreadsheet, often known as worksheets in Excel. If you see an Excel document that has "Sheet 1", "Sheet 2" and "Sheet 3" tabs at the bottom, then this is a workbook and often the content on these three worksheets is related.
2. How to Protect Excel Workbook
Remember how we mentioned that workbooks often contain information that is important enough to protect? Well before we learn how to unprotect workbook, let's first take a look at how to protect an Excel workbook. It is important to realize that you can protect the Workbook structure which makes it impossible to add, delete, move, copy, rename, hide or unhide the worksheets or you can protect the workbook windows which makes it impossible to change anything about the workbook and worksheet window including the size and position.
Here's how to protect the workbook structure and Windows.
Step 1: Open the Excel Workbook you want to protect and the click on "Review". Choose "Protect Workbook" under "Changes".
Step 2: In the dialogue box that appears, check both "Structure" and "Windows" and the click on "OK".
Step 3: Enter the password when prompted and then click "OK" to complete the process.
3. Unprotect Excel Workbook With or Without Password
Now we get to the reason you came here: how to unprotect an Excel workbook. In this section, we are going to offer you solutions to unprotect the workbook whether you have the password or not.
3.1 Unprotect Excel Workbook with Password
If an Excel workbook is protected, you need a password to unlock or even edit the document. If you already have the password, the process of unprotecting the workbook is very easy. The following simple steps show you how.
Step 1: Open the protected Excel workbook, enter the password when prompted and then click on "Review" and then click on "Protect Workbook".
Step 2: A small dialogue box will appear, requesting that you enter the password to unprotect the Workbook. Type in the password in the provided field and then click on "OK".
3.2 Unprotect Excel Workbook without Password
The process can be slightly more complicated if you don't have the password and unless you can find a way to figure out the password, you may not be able to open the file at all. The good news is that we have a tool that is designed to help you recover the password no matter how complex it may be. This tool is Passper for Excel, and it is a password recovery program designed to unprotect Excel documents. Some of the features that make password recovery possible include the following.
Recover opening passwords: Passper for Excel is instrumental in helping to recover Excel opening passwords without affecting any of the data on the device.
Unprotect Workbook/Worksheet: Remove worksheet/workbook protection in only 3 seconds.
Unprotect Excel from various scenarios: It can help you unlock the password if you have forgotten the password, can't copy the worksheet or workbook, can't edit the content on the Excel document or you can't print the worksheet.
Highest recovery rate: It has one of the highest recovery rates since it utilizes 4 different attack modes to make password recovery possible even when you don't know what the password could be.
It is also very easy to use. You can recover the password in just three simple steps and remove restrictions in a single click.
To remove restrictions on the Excel workbook, the following simple step by step guide will show you how.
Step 1: Install Passper for Excel on your computer and then launch the program. On the main window, click on "Remove Restrictions" and then click "Add" to import the Excel workbook that you want to work with.
Step 2: Once the document has been added to Passper for Excel, click on "Remove" and any restrictions on the workbook will be lifted. You can now edit the document any way you want.
Passper for Excel also offers you the best chance to recover the opening password on any document. The following is how to do it.
Step 1: Launch Passper for Excel on your computer and in the main window, click on "Recover Passwords". Click on the Add button to import the document into Passper.
Step 2: The next step is to select the attack type you want to use. Keep in mind that there are four attacks to choose from and the one you decide to use will depend on how much information you have about the password. Click "Next" once you have chosen the attack mode.
Step 3: The software will then begin recovering your password. This process may take a few minutes, depending on the attack mode selected. The password will be displayed on the screen when it is found. You can then use it to unlock the Excel workbook.
3.3 Another Way to Unprotect Workbook without Password
If you don't want to use a program to unprotect the workbook, there is one other way to unprotect an Excel workbook if you don't have the password. Here's the step by step guide you need.
Step 1: Open the Excel workbook in question and then hit "ALT + F11" on your keyboard to open the Microsoft Visual Basic for Applications.
Step 2: Click on "Insert" and then select "Module" in the drop-down menu that appears.
Step 3: Enter the VBA code on the module and then hit "F5" to execute the code. Wait for the process to respond (the process may take a while) and when it is complete, the workbook will be unlocked and you can proceed to edit it if you want.
The above mentioned solutions can help you unprotect any Excel workbook whether you have a password or not. It is however advisable to always keep your passwords in a safe place to ensure that you always remember them.