In order to protect data from unauthorized read or edit, we are used to setting password on office files. Today we are going to talk about Excel worksheet. If you have set a protected password on Excel file, however, you forgot excel worksheet password accidentally. Now you have no right to read or edit the data in Excel file too.
How can you unprotect Excel worksheet without password? We are going to tell you top 2 ways about how to fix that issue without any hassle. Let’s begin.
Way1: Unprotect Excel Worksheet with Command Prompt
Before you proceed with the guide to unprotect Excel worksheet, you should know this way is support for the users who lost the worksheet password, have no way to read or edit the content.
Step 1: Press Alt+F11 or click view code on the Developers Tab
Step 2: To double-click the worksheet that password protected.
Step 3: To copy and paste the code below into the window. Do not change any of the code. Just copy and paste it.
Step 4: Click on the “Run” button or Press F5. There pops up a small window saying “One usable password is xxxxxx”. You can use it to open the password protected Excel worksheet without data loss.
Note: This way maybe work for you. We have a good amount of success using this method but it has not worked 100% of the time.
Way2: Unprotect Excel Worksheet with iSunshare Excel Password Genius
If above way is not helpful to you. You can try to use an Excel password recovery program. There is a number of traditional Excel password recovery tool that available on the Internet and can unprotected Excel worksheet without password easily.
iSunshare is one of this tool that empowers you to be able to get rid of password protection at a superior speed to recover Excel 2016/2013/2010 worksheet password in just minutes. With its simple interface, you can handle it in the quickest way.
Step 1: First to Download, install and launch Excel Password Genius on your computer.
Note: You can test its functions from free trial version. It only works for the password less than 4 characters.
Step 2: Click “Open” button to import password protected Excel file to the Microsoft encrypted file.
Step 3: Now you can choose password attack type. There are four types for you. Respectively are Brute-Force, Mask, Dictionary ,and Smart.
Note: It is necessary for you to select one appropriate attack type to improve password recovery speed.
Step 4: After browse attack type, remember to make detail settings of it.
Step 5: Click “Start” button to start Excel worksheet password recovery process. Several seconds later, you can copy pop up window password to open protected Excel worksheet efficiently.
Note: Excel Password Genius supports all versions Excel file. You can use it in anytime, anywhere.
In the end, we can see that iSunshare gives us a variety of options to unprotect Excel worksheet. No matter how complex the password is, you can recover it in simple and secure way. In the process, this tool does not harm your worksheet or data, so you have nothing to lose from trying it.