How to Open a Password Protected Excel File if Forgot Password
When we are creating password protection on our Excel workbook, Microsoft warns us to keep our password in a safe place, because they can't help to find back the password if it is forgotten or lost.
However, if you are unfortunate to forget your Excel file protected password, how to open it?
If there are a lot of important data on the Excel workbook, deleting it directly will cause an amount of loss. Is there any way to unlock it without losing data? Follow this article, and use the software on the method to open your Excel file without or with password efficiently and no any damage.
- Methods to open Excel file:
- Method 1: Open a password protected excel file without password
- Method 2: Open your Excel workbook with the encrypted password
- Method 3: Unprotect Excel spreadsheet without software by VBA code
Method 1 only works on Excel (*.xls) file; method 2 works on Excel (*.xls ,*.xlsx) file; method 3 only works on Excel spreadsheet. Read and choose the appreciate way to unlock your Excel file.
Open a password protected excel file without password
The Office Password Remover only works for (.xls and .doc files) on the lower version of Office 2003 . If you are using the higher version of Excel (.xlsx) file on Excel 2007, 2010, 2013, 2016, go and see the next method.
1. Download Office Password Remover, install and launch it.
2. Click Open button and select the Excel (.xls) file which you want to unlock.
3. Click Remove Password button, the protected password will be removed from your Excel workbook in a soon.
4. Click on Open, you will find the Excel file is unlocked without password.
Open your Excel workbook with the encrypted password
If you forgot protected password to open .xlsx file on Excel 2007/2010/2013/2016, follow this way:
1. Get the Cocosenor Excel Password Tuner and install it on your computer.
2. Click on Open to select the Excel file that needs to be unlocked. (The first two steps are similar with Office Password Remover)
3. Select the appropriate recovery type and adjust settings.
Select which recovery type?
4.1 Normal type?
If don't know or remember any thing about the password for your Excel file, choose the Normal recovery type, which will try all the probable combination to recover password for you.
But remember to set the password range and password length to improve the recovery efficiency.
4.2 Normal with Mask type?
If some parts of the password character are still remembered by you, select the Normal then Mask. This may be faster than the Normal recovery type only.
First choose the Normal to set the password range and password length.
Then choose Mask to specify the password, use the "?" symbol to replace with the character you don't know.
4.3 Dictionary type?
If your password is note on a document, create a password dictionary with it, and then choose the Dictionary recovery type, that will find your password in a soon. You also can use the dictionary created by the password program.
4.4 Smart type?
If your password is complicate, and you don't remember any thing about it, select Smart, which will try all the printable characters in all combinations.
5. After adjusting settings, click on Start button, the recovery program will begin.
6. After a while, when your Excel encrypted password is recovered, click on Copy, click on Open, and then paste the password to open your Excel workbook.
The Excel Password Tuner is applied to all versions of Excel file, such as *.xlsx file on Excel 2016/ 2013/ 2010/ 2007, and the *.xls file on Excel 2003/2000.
Unprotect Excel spreadsheet without software by VBA code
If you are only setting the password to protect your Excel sheet to be edited, and you forgot the unprotect password, unprotect it with VBA code instantly.
Step 1: Open the Excel file, and press Alt + F11 to open VBA window.
Step 2: Click on Insert, select Module.
Step 3: On the General window enter the VBA code.
Step 4: Click on "Run" button (or press F5 key) to run it.
Step 5: In a second, a small box pops up, in spite of the password, just click on OK to close it. Close the VBA window, you will find your Excel sheet has been unprotected without the password.
Isn't it so easy? Just have a try!
Tips: You can't use the VBA code to open a password protected Excel file when you forgot the encrypted password, because you can't insert a module when the file is not opened.
- Two options to unlock Excel Workbook with or without password
- How to open a locked Word document free without software
- How to unlock your Access Database if forgot Password
- How to unlock PowerPoint Presentation When forgot password
- How to unprotect a Word Document if lost encrypted password
- Remove MS Access database protected password
- Remove password protection from PowerPoint 2013, 2016
- Remove Protection Password from Word 2016 Document
- How to reset or recover Outlook data file password
- Retrieve *.pst file Lost Password from your Outlook Email
- Set and remove password protection for Excel 2013