How to Recover Lost Excel Password

/ Posted by Shirley Howard to Excel / Follow @Shirley Howard

If you have lost Excel password, then there is nothing you have to worry about. Excel files are important for us because we store important data on those files and we don’t want anyone else to edit them or open them. Sometimes we lock an excel file but later we forget the password. As a result, it becomes a terrible problem for us. But if you are reading this article then you can easily recover the lost password for Excel. This article will give you the best 4 solutions to easily recover the lost password for your Excel file.

Recovering an Excel password can be a little tough for you if you don’t follow proper steps and methods. Losing an Excel password can be a worst thing for you if you don’t have any solutions. But in this article you will get the proper solutions you need for your problem and the only way you can solve it is to follow each step properly.

Solution 1: Recover Lost Excel Password via VBA Code

If you are using an old version of Microsoft Excel like the versions above 2003, you can easily crack the password of a locked excel file with a VBA code. But if you are using the newer versions of excel like 2007 or later, due to their advanced level security, you won’t be able to use VBA code to crack the file password. Follow these steps to retrieve the lost Excel password.

  • Open your protected worksheet first.
  • Now, hold down “ALT+F11” keys which will open the “Microsoft Visual Basic for Applications Window”
  • Now click on “Insert” option and choose “Module” to paste the below code into the module box.
  • vba code
  • Finally, tap on F5 button from your keyboard and a pop up box will open, click “OK”. Your password will be deleted from the protected worksheet immediately.
  • one usable password delete

Solution 2: Retrieve Missing Excel Password with Compressed File

If you can't edit a worksheet and the structure of a workbook/worksheet is locked, then you can use this method. If your file is password protected, then you won't be able to use this method.

  • First you will change the file extension of the excel file from “.xlsx” to “zip”. You will be able to see the file extension after the file name of your excel file.
  • rename file
  • Now you will have to extract the zip file by using any zip extractor like 7zip or WinRAR. Right click on the zip file and choose “Extract Here”. You will get a folder with the same name of your excel file.
  • zip file extraction
  • Now open the “xl” folder and “also “worksheets” folder which will give you all the sheets of the document file. Each sheet will be named as, “sheet1.xml”.
  • sheets xml
  • Choose “Edit” by right clicking on the locked worksheet, it will open the file in notepad. Now, tap on “Ctrl+F” button from the keyboard to find "sheetProtection" or "workbookProtection" in the file. You will find the information of the algorithm that is used to lock this sheet.
  • Now, delete all the information inside the brackets and also the word “sheetProtection” and save the file.
  • Now select the file and press “Ctrl+C” to copy it and open the Zip file by double clicking on it. You won’t have to extract the file now.
  • zip file
  • This time go to the folder where you have saved the worksheet. Open the ‘xl” folder and “worksheets” folder. Your edited “workbook.xml” file will be in the “xl” folder.
  • Now paste the edited file in this folder by overwriting the old file. Finally you can close the zip file and rename the file as “xlsx” which will bring back your excel file again.
  • excel file
  • Now open the “xlsx” file, you will see that you can edit the file without the password now!

Solution 3: Restore Lost Excel Password with Online Password Recovery Website

You can easily use some online tools from websites which can help you to try more than 1000 passwords at a time for a locked file. Follow these websites, upload your file and then retrieve the password easily.

  • http://www.password-find.com
  • https://www.password-online.com
  • http://www.decryptum.com

Solution 4: Find Disappeared Excel Password with Excel Password Recovery

The best way to recover your lost Excel password is to use PassFab Excel Password Recovery tool. With a multi-core GPU acceleration, this tool will be able to retrieve your lost Excel password in almost no time. Just follow these below steps to help yourself out with this useful software.

Free Try PassFab Excel Password Recovery Now:
Free Download For Win 10/8.1/8/7/XP
Secure Download
  • Install the Excel Password Recovery software on your PC and launch it to start the process.
  • Add the Excel file and select one decryption method that matches your situation.
  • import file
  • Click on “Start” and wait till the software decrypts the password. It may take some time depending on your password.
  • recovering password
  • You will see a pop up window with your password.
  • show password

This article contains nothing but the best 4 solutions for you to recover your lost password to Excel file. But whatever solutions you choose to get along with, the ultimate solution can only be the Excel Password Recovery software. This software will retrieve your Excel password in a very short time rather than keeping you wait like the other 3 methods. Try this tool for once and you will definitely use it again for Excel password related issues.

Free Try PassFab Excel Password Recovery Now:
Free Download For Win 10/8.1/8/7/XP
Secure Download
Comment

Product-related questions? Speak directly to our Support Team >>