'I forgot Excel password and can't open a password-protected file. Anyone help me unlock it or recover lost Excel password?'
Important Excel files are usually password protected, which is a layer of protection for data. Forgot password for Excel files is a nightmare, and everyone (including yourself) can't access these valuable data in it.
All in all, Excel Password Recovery Lastic is a perfect tool to crack Excel passwords featuring wide range of functions and easy-to-use interface to master all of them quickly. Post navigation ← AnyMP4 iPhone Transfer Pro for Mac 8.3.12 Burnova 1.3.56 →. Excel Password Remover removes the password protection applied by the “Protect sheet” and “Protect workbook” commands in Excel (i.e. Enables you to edit the workbook even if you have forgotten your password). It works on the active workbook, so you must be able to open the workbook in question. It will remove passwords of any length. Free 2010 Excel Password Recovery Tool. If your 2010 excel file locked with password so don’t irritate just use SDR free 2010 excel password recovery tool that constantly ready to recover lost XLSX file password which locked by password it also attempt password recovery of Excel version 97 to 2007/2010/2013 and 2016 files. May 27, 2021 After checking the full review of Excel Password Recovery Lastic, we would like to introduce a better solution to you. The fantastic tool we want to recommend is Passper for Excel. 2.1 Introduction of Passper for Excel Compared to Excel Password Recovery Lastic, Passper for Excel is a much more popular and excellent password unlocker. Ability to quickly recover/crack Excel password without losing data. It can perform password recovery for RAR, Word, Excel, PPT, Access, Zip, and Outlook etc. 99.9% recovery rate makes you feel safer and more comfortable. Its trial version can restore Excel passwords up to 3 characters for free. Steps for (MS) Microsoft Excel.
Thus, here, I summarize 4 effective methods to help you recover Excel password.
#1. File Extension
#2. VBA Code
Part 1. Overview of Recovering Forgotten Password on Excel file
This article will introduce 4 ways to recover Excel password and unlock: VBA code, VBAProject, file extension, and an Excel password recovery tool.
Each method has its own adaptability, and you need to know it in advance.
File Extension: Only available in Excel 2010 and earlier. Its recovery steps are complex. Anyone with a technical background can try it.
VBA Code: Only works with Excel 2010 and previous versions. It can only recover a single Worksheet password at a time. You need to repeat the operation for multiple times to open all Excel files.
VBA Project: Only suitable for password recovery for older versions of Worksheet. It is more complicated than the above methods, and it requires a VBA basis. The recovery rate is not high, but it is also a way of trying.
Excel Password Recovery Tool: Applies to all versions of Excel protected Workbook/Spreadsheet password recovery. It allows you to retrieve lost Excel passwords quickly and easily.
Part 2. Restore/Crack Forgotten Excel Passwords (Older Versions)
If you want to unlock the old version of Excel, you can try it in the following 3 ways. Although they are a bit complicated, they only require you to spend time instead of money.
#1. File Extension
Step 1. Create an Excel backup with password protection. This method usually does not affect the data in the Excel file, but for security reasons, you'd better create a copy of it in advance.
Step 2. Right-click on the Excel Worksheet and select 'Rename' to change the file extension from '.csv' or '.xls' to '.zip'.
Step 3. Open the ZIP file with the unzipped app and look for the file with the suffix '.xml'.
Step 4. Double-click the XML file to open it with the XML editor.
Step 5. Press the shortcut key 'Ctrl + F' to type 'SheetProtection' into the search box and find the field '<sheetProtection algorithmName =' SHA-512 'hashValue =').
Step 6. In the XML file, delete everything between '<' and '/>' and save it.
Excel Password Recovery Lastic Crack
Step 7. Change the '.zip' file back to '.csv' or '.xls' and press Enter to confirm your operation.
Now you have unlocked protected Excel's password.
#2. VBA Code
Step 1. Open the password-protected Excel and open the VBA editor with the shortcut 'Alt+F11'.
Step 2. Right-click the Excel file in the Project-VBAProject pane, select 'Insert', and then click the 'Module' option.
Step 3. Copy and paste the following VBA code into the 'General' window that appears.
Step 4. Click the 'Run' button or press the F5 key on your keyboard to run it.
Step 5. Now, the password consisting of the letters A and B pops up. Although it is not your original password, it allows you to access it even if you forgot Excel workbook/sheet password.
Firstly, Create a New Virtual Excel File and Set a Password
Step 1. Create a new Excel file. Then click on 'Macros' in the menu bar that appears.
Step 2. Now enter any Excel name and click 'Create'. Its name is not important, but you can't skip this step.
Step 3. This range ('A1'). Value = 'Password Protected' code is copied and pasted into the VBA editor.
Step 4. Then click on the 'Tools' option in the editor and click on 'VBAProject Properties' in the drop-down list.
Step 5. Set a new password in the 'Protection' tab, you need to remember this password.
Step 6. Click 'OK' to save the Excel file as an XLSM file.
Secondly, Prepare the vbaProject.bin File
Step 7. Rename XLSM to a .zip file and open it with an unzip app. Then open vbaProject.bin under the xl folder.
Thirdly, start Recovering Lost Excell Password
Step 8. Use the shortcut 'Ctrl + F' to find the string starting with 'CMG ='. Now you need to enter the code shown below, starting with:
Step 9. Save this edited HEX file. Overwrite the original file with the edited vbaProject.bin file.
Step 10. Change its file name back to *.xlms or * .xls
Step 11. Now open the encrypted file, go to the 'Developer' tab and select 'Visual Basic', then click 'Project', you should see the password of the virtual document in the pop-up password prompt.
You can open an encrypted Excel file with this password. If you are using an older version of Excel, you don't have to worry if you've forgotten Excel password on Excel file.
Part 3. Best Solution to Forgot Excel Password 2013/2016/2017 (All versions)
For password recovery in Excel 2013/2016/2017, the first 3 methods are invalid. Now I will introduce a perfect tool for Excel password recovery - Password Genius to help you get out of the woods. Its versatility and user-friendly service are powerful weapons that make it far beyond peer software.
What Are the Advantages of Password Genius?
1. Ability to quickly recover/crack Excel password without losing data.
2. It can perform password recovery for RAR, Word, Excel, PPT, Access, Zip, and Outlook etc.
3. 99.9% recovery rate makes you feel safer and more comfortable.
4. Its trial version can restore Excel passwords up to 3 characters for free.
Steps for (MS) Microsoft Excel Password Recovery:
Step 1. Download and install Password Genius on the computer. You need to select the appropriate folder to save it.
Step 2. Launch it, then click the first option 'Recover Passwords for Files and Archives'. Of course, you can do this by selecting 'File and Archive Password Recovery' on the left.
Step 3. Select 'Excel Password Recovery' to restore the Excel password. You can also use this integrated software to crack passwords for Word, PPT, Outlook, RAR, ZIP and PDF.
Step 4. The folder icon with the + sign on the right can help you import the encrypted Excel file, click on it and select the desired file.
Step 5. Select the attack type and set the relevant options, then click the 'Start' option below. The 'Stop' button on the right allows you to stop recovery at any time.
There are 4 ways to break an encrypted file: 'Brute-force', 'Mask', 'Dictionary' and 'Smart'. Each attack has its own settings. The appropriate settings will speed up your recovery of the Excel password.
Now let's see how to make the best settings!
'Brute-force': As you can see, after selecting the 'Brute-force' mode, marking the relevant options under 'Length' and 'Range' can reduce the time it takes to recover the password.
'Mask': The 'Mask' attack takes one more step than the 'violent attack' and takes less time. After selecting mode and options, you need to enter the known password characters and replace the remaining unknown characters with '?' in the box to the right of 'Mask'.
'Dictionary': This attack mode requires you to create a TXT document in advance and type all possible Excel passwords in it. Then, select the 'Dictionary' attack mode and the 'Dictionary' tab, and click 'Select Dictionary' to choose the created TXT document.
'Smart': Selecting it means you can't change any settings, only let it automatically recover your password. This requires a higher cost of time.
Step 6. Click the 'Start' button to find and recover the password. After the following interface appears, 'Copy' the Excel password to the clipboard.
Another tool worth recommending is PassFab for Excel. When you forget your excel password, you can use Dictionary Attack, Brute-force with Mask Attack, Brute-force Attack three modes to recover excel password.
Tips: Why the First 3 Methods Fail to Recover Excel 2013/2016/2017 Password
Why are the first 3 methods only capable of recovering password from older versions prior to Excel 2010? You need to know the difference between the old version and the new version of Excel:
The length and complexity of the old Excel password do not change the extent of Excel file protection. You can use the first 3 technical methods to crack the Excel password.
For the latest version (for example, Excel 2013/2016/2017), Microsoft official offers more sophisticated technology and Excel protection methods, so hackers or technology cows cannot bypass password protection. In this case, Pro Excel password remover could be your choice.
The Bottom Line
When you forgot Excel password, you don't have to be anxious anymore. The 4 methods of Excel password recovery introduced in this article can quickly retrieve passwords for different versions of Excel. Simple or complex, free or paid, choosing the right plan to overcome password protection is the top priority.
I sincerely hope that these methods can get you out of your dilemma. If you have better solutions or more questions, share it below!
It happens sometimes that you forget the Excel password that you set thereby making it near impossible to read or modify the file which can be frustrating. With an Excel password remover, you can easily unlock and remove forgotten passwords for Excel files and workbooks. If you are currently looking for the Excel password remover tools, this article will help you out with that.
There are mainly 2 types of passwords you can find in Excel: Password to Open, Password to Modify. Some Excel password remover tools introduced in this article can remove all types of passwords while some can only remove Password to Open or Password to Modify. You can refer to the comparison table below to choose the best one in the shortest time.
|Remove 'Password to Open'||Remove 'Password to Modify'||Success Rate||Operation||Rating|
|Passper Excel Password Remover||100%||Remove in only 3 steps, very easy.|
|SmartKey Excel Password Recovery||95%||Complex, the interface is not simple.|
|SysTools Excel Password Recovery||93%||Not easy to use, errors always occur.|
|iSumsoft Excel Password Refixer||95%||Easy to use.|
|PassFab for Excel||90%||Easy to use.|
|iSunshare Excel Password Remover||97%||Easy to use.|
|Stellar Phoenix Excel Password Recovery||93%||Simply to use, but the interface is very old.|
|Excel Password Recovery Master||95%||Easy to use, but the password cannot be removed in one click.|
|Daossoft Excel Password Rescuer||90%||The user interface is not simple.|
|Accent Excel Password Recovery||97%||A bit complicated.|
|Passware Excel Key||93%||The user interface is not simple.|
|Password-online.com||97%||Easy to use, but the data may get lost.|
|Password Protection Remover Pro||97%||Easy to use.|
|Excel Bee Password Remover Macro||95%||Very complex and difficult.|
Now you can directly jump to your favorite Excel password remover in this article:
Part 1. Excel Password Remover Software
1. Passper for Excel (100% Working)
This is an effective, quick and easy way to recover any passwords for your Excel document or remove protection for read-only Excel sheet. Passper Excel Password Remover has 4 attack modes with which you can use to recover the password without modifying or damaging the data saved on the Excel file. And it is compatible with Excel versions ranging from 2003 to 2019.
Core Features of Passper for Excel:
Remove the opening password for a password protected Excel document.
Removing password protection and read-only protection from your worksheet or workbook to edit, copy or print with 100% success rate .
The length or complexity of your MS Excel password does not matter. Passper for Excel will recover any types of Excel password for you within minutes.
It supports Multi-core CPU and GPU Acceleration to highly speed up the recovery process.
Advanced algorithms are used to highly increase the success rate of password recovery.
The developer of Passper: iMyFone has received a lot of good reviews from Cult of Mac , Makeuseof and other well-known medias. Besides, we also receive Letter of Thanks from our users.
2. SmartKey Excel Password Recovery
With SmartKey Excel Password Recovery tool, you can recover the password for any Excel xls/xlsx file no matter how long or how complex it is. It can recover password for Excel versions from 2019 to the older versions. This tool offers standard version and professional version, but neither of them can remove Excel password. Here are the features of SmartKey Office Password Recovery.
Features of SmartKey Excel Password Recovery:
Unlock Excel document and Excel worksheet/workbook.
Supports to recover Excel password online.
Fully compatible with Excel 2019, 2016, 2013, 2010, 2007, 2003, etc.
3. SysTools Excel Password Recovery
With SysTools Excel Password Recovery tool, you can unlock any Excel file instantly. It can recover the password of many Excel files at once and keeps the integrity of your Excel file. This is an easy-to-use Excel password remover tool that supports all versions of Windows operating system. However, the latest Excel 2019 is not supported by the program now.
Main Features of SysTools Excel Password Recovery:
It features multilingual cracking and retrieval of passwords.
It features zero limitations on file size.
It keeps data integrity after password removal.
It features a function that removes passwords from multiple files simultaneously.
4. iSumsoft Excel Password Refixer
This is a trusted excel file password recovery software that offers high password recovery rate. Based on the powerful algorithm and advanced GPU acceleration, it can recover passwords of any length or complesity within the shortest time. However, the last update of this tool was in 2018.
Main Features of iSumsoft Excel Password Refixer:
It features four powerful attack modes.
It supports the two tpes of Microsoft Excel workbook which are xls. and xlsx.
It supports Microsoft Excel versions through 97 to 2016.
5. PassFab for Excel
It is an powerful and straightforward excel sheet password remover, and it comes in two versions – the free version and paid version. However, the free version cannot recover or remove password for you. You can only use it to check whether your file is supported or not. Besides, the recovery time is relatively longer than other tools since it only provides you with 3 recovery methods.
Main Features of PassFab for Excel:
It features three attack modes - Brute, Dictionary and Mask Attack modes.
It is compatible with all versions of Windows and all versions of Excel.
6. iSunshare Excel Password Remover
It is a flexible Excel password remover. The removal speed is greatly increased based on multiprocessor systems and multi-core CPU. The password protection can be removed just with few seconds. However, it can only remove Excel opening password so far. If your Excel worksheet or workbook is restricted from editing, this tool won't work for you.
Main Features of iSunshare Excel Password Remover:
It supports Excel version XP/97/2000/2003.
The tool only supports .xls file so far.
It works with all versions of Windows.
7. Stellar Phoenix Excel Password Recovery
This is another powerful program that you can use as your Excel password remover to unlock your locked Excel files. It works with the brute-force attack which delivers a 90% success rate, and it is free to download and performs excel password recovery free. However, according to the information on the official website of Stellar, the program has been discontinued permanently. Users are unable to download and get the program now.
Main Features of Stellar Phoenix Password Recovery Tool:
It features two attack modes - Brute attack and Mask attack.
It features password length specification. That is, users can specify the minimum and maximum lengths of the password they are trying to recover.
It features a process dialog that displays the recovery process status and when it is expected to be completed.
8. Excel Password Recovery Master
This is another one of the most effective password recovery software that retrieves lost password. This tool supports all major types of password, such as Password to open, Password to modify, Workbook password, Worksheet password, VBA project password and Shared workbook password. However, the recovery or removal of the 'Password to open' for MS Excel 2007/2010/2013 is not supported by the program.
Main Features of Excel Password Recovery Master:
It features a one-click password recovery process.
It features multiple languages, including German, Russian, French, Spanish and English.
It supports both XLS. and XLSX. formats as well as all versions of Excel from 97 to 2013.
9. Daossoft Excel Password Rescuer
This excel password remover software has a user-friendly interface that is easily understandable by any user. It unlocks your Excel file using four different attack modes which are the smart attack, brute attack, dictionary attack, and mask attack. The program also offers a trial version. With the trial version, all excel passwords can be recovered, but you can only view and use 3 or less characters of password.
Main Features of Daossoft Excel Password Rescuer:
It features a GPU acceleration technology with NVIDIA or ATI video cards that are yet to be patented.
Automatically save the recovery process and you can resume it when you run the program next time.
It features the capability to choose program priority mode.
It supports Excel versions from 97 to 2016.
10. Accent Excel Password Recovery
Accent Excel Password Recovery is an excel password remover that is capable of finding your password very quickly. Just like the other software tools, it also features the various attack modes which include brute force with mask attack, brute force, and enhanced dictionary attacks. So far, you can only use this program on Windows 7 and earlier Windows editions.
Main Features of Accent Excel Password Recovery:
It supports different types of passwords.
It features three attack types.
It features a simple and user-friendly interface.
It supports Excel versions from 95-2013..
11. Passware Excel Key
This is an easy-to-use Excel password remover tool that supports all versions of Excel. Any types of passwords for Excel file can be removed instantly. You can download the free demo to evaluate the program, but it will only recover the first 3 characters for you.
Main Features of Passware Excel Key:
It supports multilingual passwords.
It also features a very simple-to-use interface that anybody can understand easily.
All version of Excel files is supported.
Part 2. Excel Password Remover Online
This is a website that scans your Excel file after you upload your locked Excel file to get it unlocked. This is not usually free as you may have to pay 10 Euros for every recovery.
Main Features of Password-online:
There is no need to download software to your PC.
You do not have to pay for the service if the password is not recovered.
It features 40-bit fast decryption.
Part 3. Excel Password Remover Add-Ins
3.1 Password Protection Remover Pro
Password Protection Remover Pro is an Add-in that was developed by the Spreadsheet1 Team. Even with the strong AES encryption used in Excel 2007 and later that makes it difficult to attack them, Password Protection Remover Pro bypasses this encryption easily. For any Excel document of version 2007 till date, this free Ribbon VBA add-in will remove the password protection.
It is also optimized for speed, which means it gets the job done within a short time. To get access to the free trial of Password Protection Remover Pro, you will have to subscribe to the Ribbon Commander framework.
Features of Password Protection Remover Pro:
It supports Excel version 2007 and later versions.
It is a paid tool, but you get to enjoy the FREE trial first.
3.2 Excel Bee Password Remover Macro
This tool works using pure VBA code, and it is an add-in that helps you remove password from a protected Excel spreadsheet. It is an simple-to-use tool, and you do not need to be well-grounded in VBA coding to use this program. The only disadvantage of this program is that it doesn't support the latest Excel version like Excel 2016/2019.
Features of Excel Bee Password Remover Macrob:
It supports Excel versions of 2003, 2007, 2010, and 2013.
It is a free tool. You do not need to pay for it.
Bonus Tip: How to Remove Excel Password with Passper Excel Password Remover
Recover 'Password to Open' in Excel file
Passper Excel Password Remover is an Excel password recovery tool that can be used to recover your Excel opening password that you have lost or forgotten.
Step 1. Launch Passper for Excel on your computer. On the main interface, click on 'Recover Passwords'.
Step 2. Import the Excel file you would like to unlock. Choose one attack mode according to your situation. Then click on 'Recover' to continue.
Step 3. After the recovery process is complete, the program will display the password.
Remove 'Password to Modify' in Excel Worksheet
Sometimes people set passwords to prevent unauthorized parties from modifying or editing their Excel files, and they end up forgetting the password. If this happens to you, often, you will be able to open your file but will be unable to edit or modify the worksheet. However, with Passper for Excel you will be able to unlock your Excel worksheet and modify it.
Step 1. Install and Launch Passper for Excel on PC. Then select 'Remove Restrictions' option.
Step 2. Choose the Excel worksheet or workbook you want to unlock from your computer. Then click on 'Remove' button.
Step 3. Wait for a while, and your Excel document will be unprotected for editing.
There are plenty of efficient Excel password remover tools that you can use for Excel password recovery or removal. Passper for Excel is one of the highly recommended programs if you ever find yourself trying to gain access to your Excel document or get the copy of Excel sheet.