Excel sheets are always of valuable importance as they contain sensitive data which is used to create database. So, considering a password protection is always recommended. It can be very frustrating if one forgets his/her password as it may lead to unnecessary inconveniences and people fail to access their documents on time. But a lot of people don’t know that it’s very easy to remove password from Excel 2013 if you forget. Here in this guide we will let you know how to remove password from Excel 2013 if forgotten. We have four of the best methods which are proven to be very effective for people searching on how to remove password from Excel 2013. Have a look at these best effective methods to remove password from Excel
This method shows how to remove password from Excel 2013 protected sheet by using VBA code. The Excel sheet is no use and nothing can be done on it if the sheet is protected. Only those portions can be viewed which are not locked, rest of the portions are inaccessible. There are a lot of formulas used in Excel and if the sheet is password protected then none of the formulas can be viewed. That is why it is necessary to decrypt Excel file to edit/view these formulas.
Here we will show you how to remove the remove password from Excel 2013 using VBA code:
Step 1: Open the Sheet that is Password Protected
The first step is to open the sheet that is password protected, you can simply open it by double clicking on the file name on your computer. Excel files usually end with .xls or .xlsx extensions.
Step 2: Convert the File in .xls Format:
If you want to remove password protection from your sheet and you are working in. xlsx extension, then first you have to convert your document into .xls extension. Here is how you can convert your sheet in .xls format.
Step 3: Open the Visual Basic Editor:
Next step is to open the visual basic editor. To open the visual basic editor simply press “CTRL” and “F11” keys together.
Step 4: Right-Click on “Project-VBAProject”:
In this step after the visual basic editor is opened click on the Project-VBA Project at the top to left panel. Make sure to open the file with .xls format saved in the previous step.
Step 5: Click on Insert on top Menu and choose Module:
Click on insert from the top menu and then choose the module which will allow you to add new module and you can add code in that module.
Step 6: Copy the Code in Module and Run 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 "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
Since all the Excels sheets are stored in database format it is not easy to remove password from the sheets and is a very tricky process to do so. Removing password from Excel sheets is very different from removing password from a computer or an email. But here in this method we will teach you how to remove password from Excel 2013 with Zip. This method may or may not work for latest Microsoft Excel versions but will surely work for the new versions.
Simply follow the simple steps given below in order to remove password from Excel 2013 with Zip.
Step 1: First, create a backup file of the Excel sheet that is password protected.
Step 2: Next, right click on the protected Excel file and rename the file name.
Step 3: Change the extension of the password protected file from “.xlsx” or “.xls” to “.zip” as shown below.
Step 4: Unzip the contents of the password protected file and search for file with the “.xml” extension from the unzipped files.
Step 5: Double click of the newly created .xml file and open the file in XML editor.
Step 6: Now in the XML editor press “CTRL+F” and find for the word “SheetProtection” and search for the line that begins with the code below:
Step 7: Simply remove the highlighted text shown above from the editor and save the file.
Step 8: Convert the .zip file back to the format it was before, and your password protected Excel file will be accessible now with no password and you can access the Excel file.
When you open you protected Excel file, a pop up box appears asking for the password to open the file. If you do not remember the password, you will not have access to the file. One of the most recommended products from Experts include Excel Password Recovery which is a very efficient software designed by experts to remove password from the protected Excel sheets of both .xls and .xlsx format. The software consists of following features:
If the file you are trying to remove password from a .xls or .xlsx format file, then Excel Password Recovery will prove to be the best choice for you to remove the forgotten password from the worksheet because of its efficiency. Below are some of the simple steps for password recovery. Below are some of the steps for the password recovery using Excel Password Recovery.
Step 1: Download Excel Password Recovery and install it on our PC.Free Download Buy Now
Step 2: Open the file which you want to recover the password from and insert it in encrypted file box.
Step 3: In the Type of Attack type drop down menu, choose the best preferred password recovery type and make other detailed settings. Brute Force is the best preferred setting to choose among all the settings.
Step 4: Click on the “Start” button as shown above to start and run the password recovery and recover the password for the Excel file.
Step 5: After the open password is recovered just copy it and use it to remove the password or set a new open workbook password.
All of us know that Cloud computing is the future and a lot of companies have already moved towards these technologies and have removed their previous traditional services to remote servers. When we search for different methods to remove password from Excel sheet online, we often come across a lot of sites recommended by the search engines.
The online platform which we recommend if you really want to remove your password online is LostMyPass. This software makes it very easy to recover MS Excel documents password.
Disadvantages of the Tool:
This method of crack Excel password online is not recommended by experts as according to them sharing your data with someone you are not familiar is not a good deal. It is not wise to use these online services for the password removal. However, there are a lot of companies who offer this service when we search online. Therefore using this tools has some pros but at the same time it has cons too.
These methods are proven very effective if you are searching how to remove password from Excel 2013 if forgotten. It can be really annoying to get stuck in a situation where you urgently need to access your Excel files but because of the forgotten password you are unable to do so. We have provided four methods to remove forgotten password from Excel 2013. Choose the method according to your need and remove the password from the Excel sheet. Good Luck.Free Download Buy Now