Microsoft Office is one of the best and organized software for managing data and transferring it from one person to other. The packaged software offers Microsoft Excel which is easier and better way of organizing data and information. A person can organize name, age, address, contact number, and other relevant information according to the requirements. It also offers Smart Art and charts features that are perfect ways to represent data graphically and help in analyzing. An Excel workbook can manage a whole project in a smart and easy way. For this much important project details, Excel offers the users to add a password in order to protect the document from an unauthorized access. It depends upon the level of the protection you need and then set the password on prevention of seeing the workbook entirely or just restricting editing the content in it.
The password setting is a simple way, and anyone can easily put a password on it. Sometimes, a person forgets the password, or you need to bypass the security for not having the person to let you know the password. So here we have came up with three simple ways of removing password from Excel.
iSunshare Excel Password Genius is the best and most flexible Excel password remover for assisting you if you lost or forgot your password. It helps you to remove password from excel 2016 and the older versions. It is one high speed recovery software which is on top of the list among all other methods and software because of its support to all Excel versions including 97, 2000, 2003 or latest ones. It is perfect to remove MS Excel forgotten password within a few seconds.Free Download Buy Now
The iSunshare is the fastest way of removing passwords from excel files. It has an easy to operate and user-friendly environment and it has the ability of getting resumed when the computer is turned on after the last save.
Step 1: Importing the Password Protected Excel file
Click on the Open button to set the path of Encrypted file in the “Encrypted File” text box.
Step 2: Choose Password Recovery Type
Click on the dropdown menu in the “Recovery Type” area right along the Encrypted File box. You will see four types including Normal, Mask, Dictionary and Smart. Select the appropriate type from the menu to move forward.
Normal Recovery – The normal recovery works by testing all possible combinations in the specified characters range. Short passwords can be recovered within a few minutes through this type.
Mask Recovery – If you remember the password partially, this type can help you. This method is better than the normal one.
Dictionary Recovery – This one helps you if your password is a keyword and then it can be downloaded from the internet.
Smart Recovery – it is automatic and tests all the combinations until the right one comes up.
Mask Recovery is highly recommended in Excel password removing.
Step 3: Set the Parameters
In Mask type, set the range and enter Mask settings. It will speed up the recovery process. In the Mask option, write the partially remembered characters of the password and ? in place of forgotten characters.
Step 4: Recover the password by clicking on Start button
Click on the Start button right next to the Open button and then a window will appear with the password. You can directly open the file or copy the password as per your wish.
Sometimes you need to unprotect the excel sheet on urgent basis and you do not have any online resource to detect password for you the you just need to follow these simple steps to remove password from excel 2013 and other versions as well.
Step 1: Enable the Extensions with the Excel files display
For enabling the file extension, uncheck the already checked “Hide extension for known file types” option in Show or hide file extension settings window. Click on Apply and then select OK.
Step 2: Change the File Extension
Now change the file extension by right clicking the file in Window Explorer. Click on Rename and Change the extension from .xlsx to .zip.
Step 3: Open Zip Folder to edit XML file
Now after changing the extension the file changed into zip folder. Now follow the steps:
Double click the zip folder and open.
Open the .xml file
Drag and drop the .xml file on desktop and open with Notepad.
Step 4: Edit .xml file
Open the .xml file and search for sheet protection and remove the entire tag along with that.
Step 5: Save and Finalize
Save the file and close. Replace the updated file with original one and change back the extension.
There is another wise and simple way to remove password from excel 2007 and other versions and that is using the VBA code. This method generates an alternative and useable password for your excel sheets.
It can be done in 3 to 4 steps.
Step 1: Open the VBA
First open the Encrypted Excel file and press Alt+F11 to open VBA. Now double click on the worksheet you need to unlock. A declaration page for the sheet will appear.
Step 2: Cut and paste code breaker code
In the declaration page, add the breaker code. Just cut and paste it.
‘Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Step 3: Run and use the code
Press F5 and run the code. It will generate the code for your Excel file. Use it for unlocking.
If you have lost or forgot the Excel file access password and don’t know how to remove password from excel 2010, then these above methods are easier and simpler as well as genuine ones to remove passwords within a few minutes.Free Download Buy Now