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.
Click "+" to import Excel spreadsheet whose open password you want to recover.
Choose the attack type and set parameters accordingly to recover lost excel passwords.
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.
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.
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.
Now, hit on “+” sign to import the locked excel file and then, click on Remove to begin removing the 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.
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.
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.
Click on Upload and choose the password protected excel file.
When it’s uploaded, select 'Replace Spreadsheet’ and then, click on 'Import Data'. It will open up the protected excel sheet.
Go to the File > Download as > Microsoft Excel. Now, your excel file is not password-protected anymore.
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.
Right-click the file and open it with 7-Zip prgram. Next, navigate to xl folder, and edit your encrypted workbook.
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.
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.
Now, a dialog box will open. Copy paste the below code:
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
After pasting the code, click "F5" to execute it and let the system unlock the password.