Forgot Excel password and wondering how to get those precious data back? Don’t be panicked as we can help you overcome this issue. As you already know, using a password for Excel is a safety measure to protect data. As long as you know the password, you can open the respective spreadsheet and work. However, the problem arises when the respective password is forgotten. If you are facing such a problem now, you can make use of the solutions mentioned here.
Solutions to use if you forgot Excel password
There is no shortage of people who add passwords to the Excel files to limit access or modification. However, as you may already know, many individuals come across this “forgot Excel password” issue. Needless to mention that it can be frustrating because users may lose valuable files. However, if you forgot Excel password, there are several ways to unlock those files.
Unlock the Excel password you have forgotten
If you are facing a situation where you forgot Excel password, there are a couple of methods to use. Mentioned below are those methods so you can try them and get rid of the issue.
1. Use Passper for Excel Password Unlocker
Passper for Excel Password Unlocker can be considered one of the best and easiest tools. This tool can unlock your Excel password without affecting the important data in the respective spreadsheet. In addition to that, this tool also features a very impressive success rate because it uses powerful algorithms. Mentioned below are the most notable features of this Excel Password Unlocker.
- Passper comes with four attack types. They are; Combination Attack, Dictionary Attack, Mask Attack, and Brute Force Attack. As a result, the process will be shortened in addition to increasing the success rate.
- This tool is proven to be 100% working when it comes to unlocking worksheets/workbooks within seconds.
- The process with Passper is straightforward. It is possible to recover the forgotten Excel password with very easy and clear steps.
- It comes as a desktop application. So, it allows you to unlock the Excel file on your computer. As a result, your data privacy is 100% guaranteed.
- This software is compatible with Microsoft Excel versions from 97 to 2019.
- It doesn’t feature any limitation of the file size.
In fact, Passper is a reputed sub-brand that comes under a well-known company called iMyFone. Numerous well-known media sites highly recommend them. For instance, sites like Macworld, Makeuseof, PC World, and many other sites appreciate this software. Moreover, this tool has also received a large number of impressive positive customer reviews on Trustpilot. So, it can be said that this password unlocker is trustworthy to use.
Check out the steps below so you can get your password-protected Excel file unlocked easily.
- First, download and install Passper for Excel. Then, launch it. Now, you’ll see the main interface of the software. You should now choose the option called “Recover Passwords.”
- Now, you should click on the “+” icon so you can import the excel file. This is the file that you simply want to recover its password. After you have done this, you’ll be able to choose one attack mode consistent with your own situation.
- Well, you should wait patiently and await the recovery process to be completed. The recovery time is closely related to the password complexity as well as the recovery type you select. Once your password is displayed on the interface, you will be able to copy it. Just paste it to your encrypted Excel file and open it.
Besides, let’s learn more about how to remove password from Excel file easily.
2. Recover Excel password using PassFab for Excel
PassFab for Excel is another powerful, impressive tool that can fix forgotten open and restriction password for Excel. In fact, this method works for nearly all versions of Microsoft Excel files you use. Basically, it can unlock all of your Excel passwords very easily as it utilizes several attacks. PassFab for Excel works for both workbooks and spreadsheets and supports fast cracking as well. Mentioned below is how to use this program to unlock Excel files.
- First, download the PassFab for Excel and get it installed. Then, launch it. Once it’s launched, you should choose the “Recover Excel Open Password” feature.
- You can see a new window. Click on “+,” and that will allow you to import an Excel spreadsheet whose password is forgotten.
- This software comes with three attack options—namely, Brute Force, Brute Force with Mask and Dictionary. You should choose the attack type and set parameters accordingly.
Important: you should use Dictionary Attack once you have already got a dictionary file. However, Brute Force with Mask Attack, it allows you to crack the password with any part you remember. When it comes to Brute Force Attack, it tries all the possible combinations to unlock the password.
- Now, you should click on the option called “Recover.” This will bring up the Excel password recovery mode. Please note that it’s going to take time, depending on the password length and its complexity.
- Your password will be found when the attack is complete. To make it easier, a separate window will appear with the foundation that is found.
3. Use an online tool when you forgot Excel password
Some individuals do not want to use any third-party program on their PC for any reason. If that is the case, you may attempt to use a password recovery tool based on the web. Although it may help you to unlock Excel password online, it requires a stable and powerful internet connection. You are also required to upload your file to its server to proceed with the recovery. So, if your Excel file includes some sensitive information, this is not the best method. As long as you have a powerful internet connection and do not mind uploading files, follow the steps below.
- First of all, you should go to the official website of Password Online Recovery.
- Now, you should click on the option called “Upload your encrypted file” to proceed. Then, you can upload your Excel file.
- Once you have done the uploading, be sure to input a legitimate email-address.
- Reach your email inbox box to activate the decryption process.
- Be patient and wait so the tool will recover the password for you. You will get a notification notified through email once the recovery is successfully completed. What’s more, you can have the recovered password after making the payment.
4. Recover a Forgotten Excel Password for the purpose of modifying the file
Have you set a password for unauthorized modifying? And, now you have forgotten the worksheet/workbook password? If that is the case, you’ll be unable to form any changes to your workbook or sheet. If you’re facing such a situation, you’ll be able to remove this restriction with the methods below.
4.1. Use the One-click method to unlock forgot Excel password to modify
With the tool called “Passper for Excel Password Unlocker” (that we mentioned above), you can do it. In fact, it allows you to unlock the password to modify with a single click.
Follow the steps below to get it done.
- First, download Passper for Excel Password Unlocker and install it. Launch it and choose “Remove Restrictions.”
- Now, choose “Select a File.” So, you can proceed to import the Excel worksheet you would like to get rid of restrictions.
- Choose “Remove” and wait for a couple of seconds.
4.2. Use a VBA Code to unlock an Excel Worksheet
The next method is performed using VBA Code. However, please note that this method will only work for Excel 2010, 2007, and earlier version. If you forgot Excel password on the 2013/2016/2019 versions, you should check other methods we introduced.
Important: You must also realize that this method works only with single Microsoft Excel sheets.
If there are multiple sheets whose passwords are forgotten, you should use the process for every sheet. You should open one sheet after the other and see if you can decode the password. Mentioned below are the steps to follow.
- First, you should launch the Excel File whose password is forgotten.
- Now, press the Alt key plus F11 on your keyboard. As a result, the VBA window will appear.
- Now, you should click on the option called “Insert” in the Toolbar and choose “Module” from the options.
- Now, you should enter your VBA code on the VBA window.
- And now, you should press the F5 key. As a result, the code will run.
- You should now wait for some time. Now a different menu will appear, and your password will be displayed. Write the password down and use it to unlock your worksheet.
4.3. Unlock the forgotten Excel password using Zip
You should note that this process works only for Excel 2007 and 2019 versions.
- First, install any Zip compression tool such as WinRar, 7-Zip, etc. on your PC.
- Then, use the compression to open the Excel file. Make sure to right-click on the file and choose “Open with WinRar” (or 7-Zip).
- Now, navigate to “xl\worksheets\“.
- Locate the sheet whose password is forgotten. Right-click on it and choose the “Edit” option.
- Now, press “Ctrl” + “F” keys simultaneously and search for the tag “<sheetProtection …>” Then delete it.
- Once you have deleted it, save the file and exit the editor. Now, your worksheet is unprotected (unlocked).
4.4. How to unlock an Excel File without using Software
Do you wish to unlock your Excel file without using any software? If so, this method is for you.
- Launch Google Drive and log in to your Gmail account. Then, go to the “New” tab and choose Google Sheets.
- Click on File and then on Import.
- Now, on the popup window, click on ‘Upload.’ Then you should choose a file from your device to upload the password-protected Excel sheet.
- Once the uploading is done, select the ‘Replace Spreadsheet‘ and click on ‘Import Data.’ The protected Excel sheet will be opened in Google Sheets.
- Go to the option called “File.” Then, click on ‘Download As‘ and select ‘Microsoft Excel.’
- Once you have opened this new file, you can locate the worksheet/workbook, and it isn’t password-protected anymore.
The uploading speed of the file is actually slow. So, the loading process is susceptible to stuck if there are several worksheets in your Excel file. In addition to that, the file you downloaded from Google Sheets will appear in Protected View. So, you should enable editing manually.
Is it possible to edit a Forgot Excel password on Mac?
As you can clearly see, the above solutions we explained are mainly for Windows users. If you are a macOS user, you’ll be wondering whether you’ll recover forgotten Excel password. Well, there’s good news for you, so keep reading.
Do you want to unlock the forgotten Excel password and edit an Excel file? In that case, the methods as mentioned earlier, like using VBA code and ZIP software, are practical solutions. Nevertheless, to recover the forgotten password to access your Excel file, there are only two practical ways. They are; using the Keychain Access program or transferring your Excel file to a Windows computer. After transferring it to Windows PC, you can use any of the tools mentioned above and crack the password.
Here’s how to do it with the Keychain Access Program.
- Go to the “Application” folder on the Mac. Then, go to “Utilities” and click on “Keychain Access” to open it.
- Locate the option called “Passwords” located in the left panel of the Keychain Access program and click it.
- You can see a “Name” column. It is located at the top-left of the program’s main screen.
- Go down and locate “Excel.” Click it.
- A different screen will come out. Check the option called “Show password” under the “Attributes” tab. Another screen will appear and then enter the “login” Keychain password.
- Now, click on “Allow” to proceed. It is possible to see the password in the “Show password” box once you have done that.
Do you know other solutions to use when you Forgot Excel password? Please let us know.