We've found that a netizen sought help from the Tech community about the topic "How to unprotect the excel sheet if forgot the password". Unfortunately, some responses expressed that no way was found.

If you have forgotten excel password, this guide contains all the information you need to recover the forgotten Excel passwords or recover lost excel password, including password to open and password to edit.

Below is a short description of top 2 methods to find Excel password we’re going to walk you through.

Part 1: Forgot Password on Excel File? Retrieve with PassFab for Excel

When it comes to bypassing the forgotten password file, nothing is as efficient and quick as PassFab for Excel. Ranked as the #1 Excel Password Remover, it is a one-stop and easy solution to “recover Excel password” and “remove excel protection password.” So to Microspft Excel password recovery, the feature "recover Excel password" is your best choice.

PassFab for Excel makes use of 3 advanced attack type to retrieve the forgotten excel passwords. No matter the Excel 2019, 2016, 2013 or more older version such as Excel 1992. We can easily recover the forgot excel workbook password.

Step Guide: How to Recover Lost Excell Password(Excel Workbook Password)

  • Launch Excel password recovery program and hit on the "Recover Excel Open Password" feature.

    forgot password on excel file – select feature
  • Click "+" to import Excel spreadsheet whose open password you want to recover.

    excel password recovery – import sheet
  • Choose the attack type and set parameters accordingly to recover lost excel passwords.

    excel forgot password to open – choose attack type
  • Click on Recover and wait until the program finds and removes your excel file’s password. You’ll see the progress bar at the bottom of the screen.

    excel forgot password to open – choose attack type
  • Once it removes the password, a confirmation window will pop up. Click on Copy and OK to recover lost excel password, then open the excel file.

    excel forgot password to open – choose attack type

Step Guide: How to Recover Forgot Excel Sheet Password

When you forgot password to excel sheet, PassFab for Excel also helps you remove protection password for Excel sheet. You can assure that your data of Excel won't be modified. Its success rate up to 99.9% and remove the sheet password-protected quickly in minutes.

  • Run PassFab for Excel to open the Home Interface and click on the "Remove Excel Restriction Password" feature.

    forgotten excel passwords - choose feature
  • Now, hit on “+” sign to import the locked excel file and then, click on Remove to begin removing the password.

    forgotten excel passwords - choose feature forgot password for excel spreadsheet - remove password
  • The program will take hardly a few minutes to completely remove the restriction password. Hit on Open Folder and start editing the excel file.

    recover excel password – successfully removed

Part 2: Fogotten Excel Passwords? Recover via Password Online Recovery

There’re many methods available online to help users open the password protected excel files. However, you must know that your files are insecure when you use web-based programs as third parties or intruders may access and infect your Excel spreadsheet with malware.

  • On your computer, navigate to LostMyPassword website. You may choose any other tool of your liking.

  • On the home page, hit on “click here” to import the password-protected Excel file. The program will start removing the password automatically.

    excel forgot password to open – lost my password

Wait until the program cracks the password and shows it on the screen, then note it down and use it to open the excel file.

Part 3: Recover Forgotten Password on Excel File with Google Sheet

Actually, using Google Sheet, you cannot recover your password from the protected-file. You can just unload your Excel data to Google sheet to create a new online file. But this is a good choice, if you want to open the Excel which you forgot Excel file password.

Before using it, create a backup of your Excel spreadsheet and then follow the blow steps:

  • Login to your Google Account and click on the New tab. Then, select Google Sheets.

  • From the upper tab, click on File > Import to open a dialog box as shown in the figure.

    excel forgot password to open - import excel
  • Click on Upload and choose the password protected excel file.

    forgot password on excel file - select a file
  • When it’s uploaded, select 'Replace Spreadsheet’ and then, click on 'Import Data'. It will open up the protected excel sheet.

    xlsx password recovery - replace spreadsheet
  • Go to the File > Download as > Microsoft Excel. Now, your excel file is not password-protected anymore.

    lost excel password - save file

Excel Sheet Tip 1: Forgot Password for Excel File? Recover Excel Password with ZIP

The users who have forgotten the excel password can use ZIP software to get back the document. This method helps you access the file directly and it works only for excel version 2007, 2010, and 2013. So, if you’re using any other excel version or the workbook prompts for password prior to opening, please skip this part.

Here’s how you use ZIP software for xlsx password recovery:

  • Start the downloading and installing the 7-Zip tool. You can also use WinRAR or some other ZIP supported compression tools.

  • Now, rename the excel file extension ".xlsx" to ".zip" and hit on "Yes" if you see the prompted warning.

    forgotten excel passwords - rename file
  • Right-click the file and open it with 7-Zip prgram. Next, navigate to xl folder, and edit your encrypted workbook.

    lost excel password - workbook xml
  • Now, save the XML file and put it back in the same zip folder replacing the old one. Finally, rename the file back to .xlsx from .zip and you’ll be able to access it without password.

Excel Sheet Tip 2: VBA Code [Solve Forgot Password for Excel File]

VBA code is another proven method to recover excel password with ease. This method is as simple as it can get but its biggest pitfall is that it works only when specific conditions are met.

Tips:

Work for Excel version 2010, 2007 and earlier. For excel versions newer than 2010, first save the document as Excel 97-2003 workbook (*.xls), run the macro, and then save it back to original version.

If Excel file contains 2 or more protected sheets, you need to run the below code for each sheet.

  • Open your protected workbook in Microsoft Excel like any normal file. Press Alt + F11 to open the Microsoft Visual Basic for Applications.

  • Right click on the workbook name and select Insert > Module and then, paste the below code in the "Module" window as shown in the figure.

    forgot password for excel file - excel vba module
  • Now, a dialog box will open. Copy paste the below code:

    Sub PasswordRecovery()
    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
    forgot password for excel file - excel vba module
  • After pasting the code, click "F5" to execute it and let the system unlock the password.

    forgot password for excel file - unlocked password vba

Conclusion

We recommend users to install PassFab for Excel software which is the most efficient and reliable tool to recover forgotten password for any Excel file quick and easily.

COMMENT