How To Set Password In Excel 2007

"I previously protected an excel file with countersign simply now I forgot the Excel password. My question is in a situation like this how can I unlock the file?"

Many people add together passwords to the Excel files to restrict admission or modification, but sometimes, it happens a lot that people forgot Excel countersign. This can be frustrating equally a lot of users may lose valuable files. But you do not have to worry about that anymore. If y'all forgot Excel countersign, there are numerous ways you can exercise to unlock the Excel file, and in this article, nosotros will innovate valuable methods that y'all tin can use to unlock Excel password.

Situation1. Unlock Forgotten Excel Password to Open the File

How to open up a password protected Excel file if forgot password? If you are in such a situation, and so try the ii methods below.

1.1 The Best Method: Passper for Excel Password Unlocker

Passper for Excel Password Unlocker is the easiest and most effective tool when it comes to unlocking forgotten Excel password. It can unlock your Excel password without affecting the data in the file. This tool also has a high success charge per unit equally information technology uses powerful algorithms to unlock the password. Below are the main features of this Excel Password Unlocker.

It features 4 assault types namely Combination Assail, Dictionary Attack, Mask Assault and Brute Force Attack to shorten the recovery fourth dimension and increase the success rate.
The tool is 100% working to unlock worksheets/workbooks within seconds without password.
It is easy to use. You lot tin recover the forgotten Excel countersign equally piece of cake as ane-two-three.
Since information technology's a desktop awarding, you can unlock the Excel file on your estimator. Therefore, your data privacy is 100% guaranteed.
It supports Microsoft Excel versions from 97 to 2022. And there is no limitation of the file size.

Passper is the sub-brand of the high-tech company iMyFone which is highly recommended by well-known media sites, including Macworld, Makeuseof, PC Globe, etc. It has also received positive customer reviews on Trustpilot. Therefore, this password unlocker is trustworthy to use.

Free Download for Win 10/8.1/8/7/XP

You tin can check the simple steps below to unlock password protected Excel file:

Step 1 Launch Passper for Excel, and you will see the main user interface. Cull "Recover Passwords".

Stride 2 Click on the "+" icon to add the excel file that you want to recover its password. Once you lot do this, you lot can choose i attack mode according to your own situation.

Step three You can now take a residual and expect for the recovery process to complete. The recovery time is closely related with the password complexity and the recovery type you choose. After the password is displayed on the interface, yous can copy information technology to your encrypted Excel file and open up information technology.

You can sentry this video to know how the program works to recover opening passwords for Excel files.

ane.2 The Common Method: Recover Forgotten Excel Countersign Online

If yous do not want to install whatsoever third-party program on your personal computer, yous can try to utilise an online recovery tool. It's definitely easy to unlock Excel password online, but it requires stable and powerful internet connexion. What's more, it's worth mentioning that you demand to upload your file to its server to proceed the recovery. We do not recommend you lot to apply this method if your Excel file includes some sensitive information.

For the users who have powerful internet connection and don't listen uploading files, following steps will assist you unlock your Excel files.

Step 1: Navigate to the official website of Password Online Recovery.

Step ii: Click on "Upload your encrypted file" to upload your Excel file.

Step iii: Later on uploading, you need to input a valid e-mail-address.

Pace 4: Check your e-mail box to actuate the decryption process.

Step v: Expect for the tool to recover the password for y'all. You will be notified through electronic mail once the recovery is over. The recovered password will be sent to you later on payment.

Situation 2. Unlock Forgotten Excel Countersign to Modify the File

If you have set up a password for unauthorized modifying but you have forgotten the worksheet/workbook password, you will be unable to make any changes to your workbook or sail. If you are in this situation, yous tin can remove this restriction with the methods beneath.

two.i Unlock Countersign to Modify on All Excel Sheets in 1 Click

With Passper for Excel Countersign Unlocker that we mentioned above, y'all tin can unlock the password to modify in just one click even if multiple sheets are locked from modifying. Here are the steps to follow:

Free Download for Win 10/viii.1/8/7/XP

Step ane Install and launch Passper for Excel Password Unlocker tool. Select the "Remove Restrictions" on the main carte.

Step 2 Click on "Select a File" to add the Excel worksheet you lot want to remove restrictions.

Stride three Click on "Remove" and the restrictions countersign will be removed inside seconds.

Here is the video guide:

two.ii Unlock Excel Worksheet with VBA Code

The second method we will exist looking at is using VBA Code. This method will only work for Excel 2010, 2007 and earlier version. If you forgot password of Excel 2022/2016/2019, please cheque other methods we introduced in this article.

Note

You have to know that this method is just effective with single sheets. If you lot have multiple sheets that you take forgotten their passwords, y'all will demand to run the code for each canvass by opening them 1 afterward the other.

Step ane: Open the Excel File that you have forgotten the password.

Step two: Press Alt fundamental plus F11 on your keyboard and the VBA window volition pop upwards.

Stride iii: Click on "Insert" from the Toolbar and select "Module" from the options.

Footstep 4: Enter your VBA code on the VBA window.

Step 5: Press the F5 cardinal, and the code will run.

Step 6: Look for some minutes for the VBA code to crack the Excel countersign. A new pop upwardly window will show upwardly where yous will find the countersign. Write it down and utilise it to unlock your worksheet.

2.3. Forgot Excel Password? Unlock Excel Password Using Nix

This method works for existing Excel files for 2007 and 2022 versions of Excel. Check out the steps beneath.

Footstep i. Install vii-Zip or any other blazon of Zip pinch tool such as WinRar on your PC.

Step two. Use the compression to open the Excel file. Right-click on the file and select "Open up with WinRar or 7-Cypher".

Step 3. To remove countersign protection from your worksheet, navigate to "xl\worksheets\".

Footstep four. Detect the sheet that y'all have forgotten the password. Right click on it and choose the "Edit" option.

Stride 5. Press Ctrl+F to find the tag "" and delete it.

Footstep 6. Later on deletion, save the file and shut the editor. At present, your worksheet is unprotected.

2.4. Unlock Excel File without Software

If yous prefer to unlock your Excel file without using whatever software, in that location is even so some other method for you. To avoid any data loss, create a backup of your Excel spreadsheet first then follow the steps beneath to unlock excel online.

Step 1. Open Google Drive and log in to your Gmail business relationship. Click on the "New" tab and select Google Sheets.

Footstep two. At the lefft corner of the top of the screen, click on File and then Import.

Pace iii. A dialog box volition pop upwards; Click on 'Upload' and select a file from your device to upload the countersign-protected Excel sheet.

Step iv. After uploading your excel spreadsheet, select 'Replace Spreadsheet' and click on 'Import Data'. The protected Excel sheet will open in Google Sheets.

Pace v. Navigate to 'File' and click on 'Download As', and then select 'Microsoft Excel'.

unprotect excel without password via google

Step 6. Later opening this new file, y'all will find your worksheet/workbook is not password-protected anymore.

Annotation

The uploading speed is truly irksome and the loading process volition be stuck if there are several worksheets in your Excel file. What's more, the new file you downloaded from Google Sheets will be in Protected View. You take to enable editing manually.

Tip: Is At that place Any Solutions If You Forgot Excel Password on Mac?

As you may run into, the above solutions for Excel password recovery are mainly for Windows users. As a user of macOS, yous may be wondering whether you can recover forgotten Excel countersign on Mac. Adept news for y'all! We will make everything clear to yous in this part. You can proceed reading.

If you need to unlock the forgotten Excel password to change your Excel worksheet or workbook, the above-mentioned methods similar using VBA code and Naught software can as well work on macOS. However, if yous want to recover the forgotten password to admission your Excel file, there are only 2 working ways for you lot. The 2 methods are using the Keychain Admission plan or transfering your Excel file to a Windows computer and recovering the password with a tool like Passper for Excel.

Now, we will focus on how to recover forgotten Excel countersign on Mac with the Keychain Access program. You tin follow the detailed guide beneath:

Step 1: Locate the "Application" folder on your computer and open up it. And then navigate to "Utilities>Keychain Access". Click to open up it.

recover forgotten excel password with keychain

Step 2: Observe "Passwords" in the left console of the Keychain Access plan and click on information technology.

Step iii: You will see a "Name" column at the top left of the program's main screen. Now, scroll down to detect "Excel" and click on it.

Step four: A new screen will pop up. Check "Show password" nether the "Attributes" tab. Another screen will announced and you demand to enter the "login" Keychain password.

Step 5: Press "Allow" to go along. You will see the countersign in the "Show password" box.

Conclusion

Recovering your forgotten Excel password does non accept to be stressful or frustrating. There are a lot of effective methods through which you can unlock your Excel file, and the most recommended of all is the Passper for Excel Password Unlocker. You can utilise this tool for any versions of Excel. Get your copy of the tool today!!