Forgot Excel Workbook/Worksheet Password How to Recover

Have you also come across the following situation?

“I've forgotten the workbook password for one of the excel files. It has very critical data and need your support to remove or recover the password. Appreciate any help at the earliest.”

However, Microsoft doesn’t provide anyway to recover lost password for opening Excel worksheet or recover Excel workbook password for editing.

If you cannot remember password for opening your Excel worksheet or lost password to your protected Excel workbook, how can you resolve it? In this article, I will show you how to recover Excel password for opening and editing without affecting anything of your data in the Excel file. It is easy enough for you to open your password protected Excel file and edit sheet/cells without affecting anything of your data in the Excel file.

Section 1: Recover Excel Worksheet Password and Open Protected XLS/XLSX File.

Section 2: Recover Excel Workbook Password with VBA Code.

Section 3: Recover Excel Sheet/Cells Password for Editing.

Section 1: Recover Excel Worksheet Password and Open Protected XLS/XLSX File.

To edit data in a Excel file which is protected with password, the first thing you should do is make sure that you can open the Excel worksheet. If you lost password to open your Excel worksheet, follow the guide in this section to easily recover Excel password for opening. Here I will show you how to use Excel Password Rescuer to quickly recover Excel worksheet password and open a protected Excel file. Excel Password Rescuer is a fast excel file password recovery tool which can help recover lost password for xls/sxls file which is encrypted in Microsoft Excel including 2019, 2016, 2013, 2010, 2007, 2003, 2000, etc. It is powerful and very easy to use.

key features of Excel Password Rescuer.

  • Work perfectly for all versions of Microsoft Excel: 2019, 2016, 2013, 2010, 2007, 2003, 2000, XP.
  • Optimization for multiprocessor systems make it has high recovery speed and 100% recovery rate.
  • Patent-pending GPU acceleration technology with NVIDIA or ATI video cards.
  • User-friendly interface that any new user can use it.
  • Four powerful password recovery types to recover Excel xls/xlsx file password in the shortest time.
  • Automatically save the recovery process and proceed it when you run the program next time.
  • Shut down your computer automatically when the password is recovered.

Step 1: Download and install Excel Password Rescuer on your computer.

1. Click “Buy Now” button to purchase Excel Password Rescuer full version. A moment later, you will receive a license code from email.

2. Download and install Excel Password Rescuer and then launch the software, click “Help” from menu bar and select “Register”. Enter your received code.

Step 2: Select your Excel file and recover its password for opening.

1. From Excel Password Rescuer menu bar, click “Open” icon.

2. When a dialog pops up, select your password protected Excel file which you need to unlock and then click “Open” button.

3. Choose a recovery type to recover password for the selected Excel file. There are about four types wrapped in this software, you can choose one of them to recover password in the shortest time. (Read more about this step.)

4. Upon to 3, you can set up character range before recovering the password.

5. When finish configuration, click “Start” button to start recovering password for the Excel file.

6. The software will automatically recover the password and show it to you. Copy or write down the recovered password.

7. Enter the password to open your Excel worksheet.

 

Section 2: Recover Excel Workbook Password with VBA Code.

In Excel file, users can set a password to protect workbooks from unauthorized change. If you can open your protected Excel file and need to recover password for workbook, you can use VBA code to accomplish this task without using any software. It is easy and free.

Step 1: Open your Excel file that you want to recover password for workbook. Firstly, press Alt+F11 keys to open the VBA Editor on Microsoft Excel.

Step 2: Click “Insert” from menu bar and then select “Module” from the drop down list.

Step 3: Module (VBA editor) window is open. Copy and paste the following lines of code into the window:

Sub UnprotectWorkbook()
'Unprotect Excel workbook password protection.
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)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

Step 4: Hit “Save” button, and your Excel file will be saved as a macro-enabled workbook. Click “Run” button to unprotect workbook. When unprotecting completed, you can edit workbooks in the Excel file.

 

Section 3: Recover Excel Sheet/Cells Password for Editing.

In fact, there is no option in Excel for you to recover password for sheets or cells, but you can remove the password protection. In this section, I will show you an easy and fast way to unlock Excel sheet and cells without recovering the password. All you need to do is copying the whole password-protected content saved in the Excel sheet and paste them to a new sheet.

Note: Before doing this, please ensure that the options of “Select locked cells” and “Select unlocked cells” are enabled before the sheet is protected, or you cannot copy any content from the Excel file. All the external links may be removed after pasting the protected sheet to the new Excel sheet.

Step 1. Open the Excel file whose sheets and cells are protected from modifying.

Step 2. Select all the cells in the Excel sheet by pressing “Ctrl + A” or just click the corner at the left-top of the sheet, then copy these cells by pressing “Ctrl + C” or right-click any cell and then select “Copy”.

Step 3. Create a new Excel file and open it.

Step 4: Then paste these copied cells in the new sheet by pressing “Ctrl + V”. Then save it. If there is more than one workbook in this Excel file, you need to select and copy them one by one into the new Excel file.

 

Excel Password Rescuer

Price: $ 17.95

Recover Password For(.xls, .xlsx):
  • Microsoft Excel 2016
  • Microsoft Excel 2013/2010
  • Microsoft Excel 2007/2003
  • Microsoft Excel 2002/2000/97
  • Compatible With:
  • Windows 11 (x86/64)
  • Windows 10/8.1/8/7/Vista/XP (x86/64)
  • Windows Server 2019/2016 (x32/64)
  • Windows Server 2012/2008/2003 (x86/64)
  • Windows 2000/Me/NT
  • 100% Guaranteed

  • We provide a 100% money back guarantee for the first 90 days of your purchase.
  • Professional and free technical support for you at any time. Please mail to: support@wimware.com
  • Awards

    Secure

    Promotion Products
    Related Topics