- Method 1: Open A Password Protected Excel File with PassCue for Excel –
- Method 2: Recover Lost Excel Sheet Password with VBA Code –
- Method 3: Recover Lost Excel Sheet Password using PDS Excel Password Recovery
Millions of users from world use Microsoft Excel for storing their important and crucial data. Some users make their Excel sheet password protected for security purpose. When this Excel sheet gets Encrypted then other people are not allowed to access private data. This is the best way to keep data secure and safe but sometimes it happens that some users forget their password.
Microsoft Excel users search for the solutions and different way to re-access lost Excel Sheet Password but they get failed to access lost password as well as data. Here I am suggesting a few wonderful techniques to recover lost Excel Sheet Password.
- Method 1: Open A Password Protected Excel File with PassCue for Excel
- Method 2: Recover Lost Excel Sheet Password with VBA Code.
- Method 3: Recover Lost Excel Sheet Password using PDS Excel Password Recovery Software.
Method 1: Open A Password Protected Excel File with PassCue for Excel –
Nowadays, Users trends to set password protection to prevent Excel files from unauthorized accessing or editing. If you forgot the open password to Excel document you will not be able to access Excel file.
But don’t panic, PassCue for Excel can be able to recover your Excel open password with three flexible attacks, and also be able to instantly remove Worksheet/workbook protection without wiping internal data. It fully supports all version of Excel including Excel 2003/2007/2010/2013/2016.
See how PassCue for Excel works to recover your lost Excel password:
Step 1. Free download the PassCue for Excel tool on your Windows or Mac computer, then install it and launch it. You will get the main interface like below.
Step 2. Click the Add File button to import your locked Excel files to program. Then select a suitable attack type from Step 1. There are three types for your choice: Dictionary attack, Mask attack and Brute force attack.
Step 3. Each attack type needs you to fill out the complete info in the Settings filed. Like password length, password range and affix set, then more info you can remember, the faster you will get the password.
When all settings are complete, then click the Start button to start the process. It will take some time based on your password length or complexly.
PassCue for Excel program also can be able to remove worksheet/workbook password from Excel easily. Just batch import your locked Excel files to program, and click the Start button, it will remove protection at a time.
As you can see, PassCue for Excel is really a great tool for password recovery, it’s easy, faster and safe!
Method 2: Recover Lost Excel Sheet Password with VBA Code –
Step 1- Open password protected Excel Sheet and then for VBA window press Alt+f11.
Step 2- Now click on Insert option and the follow Module.
Step 3- Enter the following code on the VBA window.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox “One usable password is ” & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Step 4- Click on “Run” button or Press “f5”.
Method 3: Recover Lost Excel Sheet Password using PDS Excel Password Recovery
For recovery of lost Excel password, Perfect Data Solutions comes up with advance solution i.e. Excel Password Recovery Software. It is the most trustful and best way for recovery. This Excel Password Recovery Software the recovery process becomes very easier by following simple steps.
Excel Password Recovery Software recovers any kind of password as- numeric, alphabetical, symbolic and special characters. This Excel Password Recovery Software provides two marvellous techniques “Dictionary and Brute Force Attack” and these are sufficient to recover forget excel password.
It works with all Microsoft Excel file versions including 97 to 2019 (32 and 64 Bit) as well as Windows versions up to 10. It is available at the lowest price and within a few minutes recovers your password.
Steps to recover forgotten MS Excel Sheet Password-
1. Install PDS Excel Password Recovery Software on your machine.
2. Click Browse button to select password protected excel spreadsheet.
3. Select the password protected Excel file and click open button.
4. PDS Excel Password Recovery Software provides 2 types of Password Recovery mode.
- Dictionary Attack mode.
- Brute Force Attack.
After this, you can successfully recover lost password without any data loss.