Как активировать passfab для excel

Обновлено: 15.05.2024

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.

Forgot Excel Password? Recover with PassFab for Excel
Fogotten Excel Passwords? Recover via Password Online Recovery
Recover Excel Forgotten Password by Google Sheet
Excel Sheet Tip 1: Forgot Password for Excel File? Recover Excel Password with ZIP
Excel Sheet Tip 2: VBA Code [Remove Forgotten Password from Excel]

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

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.

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.

Прочтите данное руководство, чтобы узнать, как с помощью данной программы выбрать оптимальный режим атаки для разблокировки зашифрованного файла Office.

Шаг 1: Импортируйте зашифрованный файл Office

После установки программы PassFab для Office запустите ее. Затем нажмите на кнопку "Добавить", чтобы импортировать файл Office, который Вы хотите дешифровать.

import files

Шаг 2: Выберите подходящий тип атаки

Информация, которая поможет Вам выбрать наиболее подходящий тип атаки:

Перебор по словарю: Если у Вас есть словарь, представляющий собой текстовый фал с перечнем основных комбинаций символов, используемых Вами в последнее время в качестве паролей, нажмите на Настройки >> Добавить словарь, чтобы быстро найти пароль с помощью встроенного или пользовательского словаря.

dictionary attack setting

Примечание : Всплывающее окно может предложить Вам обновить базу словарей. Данное действие обязательно и займет некоторое время.

upgrade dictionary

Перебор с позиционной маской: Если Вы можете предоставить какие-либо ключи к забытому паролю, нажмите на "Настройки", чтобы вручную установить настройки в соответствии с имеющимися ключами.

mask attack settings

Полный перебор: Если Вы не можете вспомнить никаких деталей пароля, рекомендуется использовать данный режим. Он по умолчанию запустит подбор всех возможных комбинаций, без необходимости установки каких-либо настроек.

Шаг 3: Запустите восстановление пароля к документу Office

Теперь нажмите на кнопку "Начать" для начала работы программы Passfab для Office. После завершения процесса просто закройте программу и воспользуйтесь обнаруженным паролем для доступа к заблокированному файлу Office.

Check the following steps on how to use PassFab for Excel.

Info: 3 Advanced Password Recovery Mode
How to Recover Excel Open Password
How to Remove Excel Restriction Password

Info: 3 Advanced Password Recovery Mode

First, you should understand the 3 password recovery modes, which are Dictionary Attack, Brute Force with Mask Attack and Brute Force Attack.

Dictionary Attack

When to Use: If you know what passwords you've ever used, and they may be your Excel file password, then please put them in a txt file and import it to our software, it will automatically find out the correct one. If you have no idea about such files, this program provides a latest password dictionary for you.

How It Works: When you choose this type, you are capable of downloading the latest password dictionary built from our software as long as you click on “Settings” option.

You can put all the possible passwords in a text document, insert the document into PassFab for Excel and then run this software, it will get your password back. Otherwise, it will recover password from built-in dictionary.

passfab for excel dictionary attack settings guide

Brute Force with Mask Attack

When to Use: If you know any clues about your password, such as length, characters, specify prefix or specify suffix, this is your better choice, then this mode is strongly recommended.

How It Works: Choose “Brute Force with Mask Attack” and hit on “Settings”. In the Settings panel, set up the best combination for your lost password. Single click on “OK” button and exit Settings. Click on “Recover” button to begin recovery.

For Example: Suppose your password is five-figure, includes “8”, “h” and “_” and the first character is “h”, then you are suggested to tick:

After these settings, you are going to get password back smarter and quicker.

passfab for excel brute force with mask settings

Brute Force Attack

When to Use: If you really have no idea about your lost Excel file password, then this is the last but not least option.

How It Works: Click on “Brute Force Attack” in the main user interface and then hit “Recover” button to perform Excel password recovery.

choose brute force attack in passfab for excel

How to Recover Excel Open Password

Video Guide

Text Guide

Open PassFab for Excel, click on "Recover Excel Open Password".

passfab for excel recover open password guide

Click on "+(Please import Excel file)" button to import password protected Excel workbook. And select one of password recovery modes to recover Excel Open Password.

passfab for excel recover open password guide

Please be patient. In a few minutes, the correct password will be displayed in a pop-up window.

passfab for excel recover open password guide

How to Remove Excel Restriction Password

Video Guide

Text Guide

Open PassFab for Excel, click on "Remove Excel Restriction Password".

remove excel restriction password guide in passfab for excel

Click on "Please import Excel file" or move your Excel file to the add box.

remove excel restriction password guide in passfab for excel

Hit "Remove" to start removing the password.

click remove in passfab for excel

Wait for few seconds and your restriction password will be removed. Click on "Open Folder" option and you will see the new file named after the beginning of text. It’s the same file but have no restriction password anymore.

Microsoft Excel is a standard tool for different sorts of data keeping around the world, it provides awesome productivity and security features. One of them is password protection, it allows user to set "Password to open" and "Password to modify" on their Excel worksheets and workbooks. If you have forgotten your password and want to know how to crack Excel passwords, then follow the solutions given below.

This solution is one of the simplest ones, if you want to know how to crack Excel password then you should probably try this out. Basically, you will have to remove password protection flag using ZIP compression tool in this method, below is step by step guide on how you can achieve this:

Step 1: Download and Install ZIP supported compression program like 7-Zip.

bypass excel password with zip software

Step 2: Open the Excel file using 7-Zip, you can do that by right clicking the file and opening it with 7-Zip program, you will see several files and folders.

crack excel password by editing zip

Step 3: Now find "xl" folder and right click on "workbook.xml" and select "Edit", this will open the file in notepad or any other editor you have installed.

crack excel password with zip by deleting tag

Step 4: Find and remove this tag completely and close the editor " <workbookProtection workbookPassword="93AF" lockStructure="1" lockWindows="1"/> ".

Step 5: 7-Zip will prompt to replace the existing XML file, select "Yes" to save modified version of Excel file.

Step 6: If you have password protection on worksheet then navigate to xl\worksheets\sheet1.xml and remove the tag " <sheetProtection … > " instead to remove password from worksheet

Step 7: Now open the excel file, your password will be removed.

PassFab for Excel is our recommended solution if you want to know how to cracking Excel password, hands down the best tool available for cracking password decryption. It features three different types of brute force attacks, with correct settings and parameters you can optimize the process greatly.

It also supports multi CPUs for greater performance and works flawlessly for almost all versions of Microsoft Excel files. You can crack, open your workbooks and spreadsheets both with this program, follow the below instructions to do so:

Step 1: Open the program. You will see below interface, Now click "Add" to import to import Excel spreadsheet whose password you want to recover.

excel password cracker via passfab for excel

Step 2: There are 3 types of attack available, Brute force, Brute force with mask, Brute force with dictionary. Choose the attack type and set parameters accordingly.

Note: Dictionary Attack can be used when you already have a dictionary file, Brute force with Mask attack let you crack the password with whatever you remember, Brute force attack will try all the combinations to unlock the password.

choose dictionary attack to crack password for excel

Step 3: Click "Recover", this will initiate brute force attack, it may take time according to password length and complexity.

recovering password for excel using passfab for excel

Step 4: Your password will be cracked once the attack is complete and a window will pop up having the password.

password cracked successfully via passfab for excel

As the name suggests, you will be using VBA code for cracking purpose. It is very simple to apply but the only problem to this solution is that, it doesn’t work with latest version of Microsoft Excel. Follow the below instructions carefully to apply this Excel password crack solution:

Step 1: Open your protected worksheet in Microsoft Excel like any normal file

crack password for excel by vba code

Step 2: Hold down "ALT+F11", it will open Microsoft Visual Basic for Application window interface.

excel cracks by vba code

Step 3: Click "Insert>Module" and then paste the below code in the Module Window, this code will be used to unlock the Excel file.

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

unlock excel password using vba code

Step 4: Once pasted, click "F5" to execute this code, prompt screen will appear then click "OK" to close it and your password will be canceled shortly.

Latest version of Microsoft Excel files can be cracked using brute force attacks, which can take long time depending on password length and complexity. Good thing about using this method is all computations of brute force attack will take place on cloud servers hence in less time password will be cracked. There are number of online services available if you want to do password crack in Excel, follow the below instructions to do so:

excel pw crackers online

Step 2: Click ‘Unprotect Your File" button.

upload password protected excel online to crack

Step 3: Upload your file and click next, your file will be unlocked shortly.

excel file password crackeronline successfully

Bottom Line

We have discussed some of the best ways to crack Microsoft Excel passwords, you can try these solutions to workbooks and spreadsheets. In the end, we have also recommended an excellent all in one Excel cracking tool you can use if other methods fail for you.

Читайте также: