"I previously protected an excel file with password but now I forgot the Excel password. My question is in a situation like this how can I unlock the file?"
Many people add passwords to the Excel files, but sometimes, it happens a lot that people forgot Excel password. This can be frustrating as a lot of users may lose valuable files. But you do not have to worry about that anymore. If you forgot Excel password, there are numerous ways you can do to unlock the Excel file, and in this article, we will introduce valuable methods that you can use to unlock Excel password.
Way 1. Unlock Forgotten Excel Password with a 3rd-Part Tool (Supports 'Password to Open & Modify')
Way 2. Open Protected Excel by Modifying the File Extension (Only Supports 'Password to Open')
Way 3. Unlock Excel with VBA Code (Only Supports 'Password to Modify')
Way 4. Unlock Excel File Using Zip (Only Supports 'Password to Modify')
Way 5. Unlock Excel File via Changing File Extension (Only Supports Password to Modify)
Way 1. Unlock Forgotten Excel Password with a 3rd-Part Tool
If you have an Excel file that you need to view or open but it is password protected, and you forgot the password, then Passper Excel Password Remover is recommended. This tool is capable of saving the day when it comes to unlocking forgotten Excel Password. PassPer for Excel recovers your password without affecting the data in the file. This tool also has a high success rate as it uses powerful algorithms to unlock the password within seconds or minutes. Below are the main features of this Excel Password Recovery.
Easily recover the Excel password to open and view the file.
100% work to remove restrictions for password-protected Excel workbook or worksheet.
It features 4 attack types namely Dictionary Attack, Mask Attack and Brute force Attack to shorten the recovery time.
No data on the Excel file will be damaged.
Easy to use and understand user interface.
It supports Microsoft Excel versions 2003 to 2019.
How to Unlock 'Password to Open' for Excel Documents
You can watch this video to know how the program works to unlock opening passwords for Excel files first.
Step 1Launch Passper for Excel, and you will see the main user interface. Choose "Recover Passwords".
Step 2Click on the "+" icon to add the excel file that you want to recover its password. Once you do this, the tool will scan the file for the complexity of the password and the encryption algorithm employed.
There are four Excel password recovery attack modes namely Brute Force Attack, Combination Attack, Dictionary Attack, and Mask Attack. Find out what each of the modes entails below;
Dictionary Attack: With this recovery mode, the program will download the updated and complete dictionary and then import the dictionary file which will then sift through the entire dictionary to recover the password to the file. This mode has a high success rate.
Combination Attack: Try various combinations of the characters you provide including letters, special characters and numbers to find your password.
Mask Attack: This mode is used for people who remember the parts of the password. With this attack type, you can set the letters, minimum or maximum length, numbers or special characters in the password.
Brute Force Attack: Brute Force Attack checks all the possible password combinations to explore the correct passwords.
Step 3. You can now take a rest and wait for the recovery process to complete. The recovery time is closely related with the password complexity and the password attack type you choose. After the password is displayed on the interface, you can copy it to your encrypted Excel file and open it.
How to Unlock Excel File from Read Only with Passper for Excel
If you have set a password for unauthorized modifying but you have forgotten Excel password, and as a result, you will be able to make any changes to your workbook or spreadsheet, you can remove this restriction with Passper for Excel. Here are the steps to follow:
Here is the video guide:
Step 1. Install and launch Passper Excel Password Recovery tool. Select the "Remove Restrictions" on the main menu.
Step 2.Click on "+" to add the Excel worksheet you want to remove restrictions.
Step 3.Click on "Remove" and the password will be removed within seconds.
Way 2. Open Protected Excel by Modifying the File Extension
This method works perfectly with Microsoft Office 2010 version and earlier versions. You should, however, note that the method may not work with the latest versions of Microsoft office. If you have a version of Microsoft Office earlier than 2010 on your computer, the steps below will help you unlock your Excel file.
Step 1: Save a copy of the password-protected Excel file.
Step 2: Right-click on the file and click on "Rename. Rename the file extension from ".xls. or ".csv. to ".zip.
Step 3: Unzip the content of the zip file and locate the file with ".xml as its extension.
Step 4: Double click on the file in XML format and open it with XML Editor.
Step 5: Press Ctrl + F and look for "SheetProtection. Look for the line that contains with <sheetProtection algorithmName="SHA-512″ hashValue=" and delete it.
Step 6: Save it and change the extension on the file from ".zip to ".xls or .csv.
Step 7: Click to open your Excel file and you will see that the password has been removed.
It works with only Microsoft Office 2007 version or earlier.
It is not 100% reliable.
Way 3. Unlock Excel with VBA Code
The first method we will be looking at is using VBA Code.
You have to know that this method is only effective with single sheets. If you have multiple sheets that you have forgotten their passwords, you will need to run the code for each sheet by opening them one after the other.
Step 1: Open the Excel File that you have forgotten the password.
Step 2: Click on "Insert" from the Toolbar and select "Module" from the options.
Step 3: Press Alt key plus F11 on your keyboard and the VBA window will pop up.
Step 4: Enter your VBA code on the VBA window.
Step 5: Press the F5 key, and the code will run.
Step 6: Wait for some minutes for the VBA code to unlock Excel password. A new pop up window will show up where you will find the password. Write it down and use it to unlock your worksheet.
Way 4. Forgot Excel Password? How to Unlock Excel Password Using Zip
This method works for existing Excel files for 2007 and 2019 versions of Excel. Check out the steps below.
Step 1. Install 7-Zip or any other type of Zip compression tool such as WinRar on your PC.
Step 2. Use the compression to open the Excel file. Right-click on the file and select "Open with WinRar or 7-Zip".
Step 3. Look for "xl" folder and right-click on "workbook.xml".
Step 4. Click on "Edit" to open the file in a text editor.
Step 5. Find the tag that looks like this "<workbookProtection workbookPassword="93AF" lockStructure="1" lockWindows="1"/> and lose the editor.
Step 6. The compression tool will bring a prompt to replace the XML file. Click on "Yes" and the modified version of your Excel file will be saved.
Step 7. To remove password protection from your worksheet, navigate to "xl\worksheets\sheet1.xml" and remove the tag "<sheetProtection …>".
Step 8. Open your Excel file and you will not have to enter any password.
Way 5. Unlock Excel File without Software
Even though there are lots of effective password recovery tools for Excel, some Excel users do not fully trust these tools. Many of them are scared that they may lose the data in their files, but fortunately, there is a solution for these people. It can fix the issue of the forgotten password for Excel without using any 3rd-party software. Here are the steps to follow;
This method only works with the version older than Microsoft office 2007. And it is not easy to understand for novice users.
Step 1. Create a new folder and move the Excel file you want to open into this folder.
Step 2. Open the folder, navigate to Organize and click on "Folder" and "Search Options".
Step 3. Select "tab view" and scroll down to uncheck "Hide Extensions for known file types".
Step 4. Click on "Apply" and the Excel extension will change from .xlsx to .zip. Click on "Yes" when the prompt asking if you want to change the file name extension pops up.
Step 5. Open the zip file with a zip tool and click on the .xl folder. Then click on "worksheets" and then "Sheet1.xml" and open with Notepad.
Step 6. Search sheet protection password = "xxxx". Delete the password in the quotation, save the Notepad and click on "Yes".
Step 7. Change the extension to .xlsx and click on "Yes". Open the Excel sheet and navigate to "Review" then click on "Unprotect Sheet".
You will be able to edit your protected sheet as well as unlock it to set a new password.
Recovering your forgotten Excel password does not have to be stressful or frustrating. There are a lot of effective methods through which you can unlock your Excel file, and the most recommended of all is the Passper Excel Password Remover. You can use this tool for any versions of Excel. Get your copy of the tool today!!