How to Remove Password from Excel 2013 If I Forgot My Password

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

• Method 1. Remove Password from Excel 2013 Using VBA Code
• Method 2: Remove Password from Excel 2013 with ZIP
• Method 3. Remove Password from Excel 2013 with Excel Password Recovery
• Method 4. Remove Password from Excel 2013 Online (Not Recommended)

Method 1. Remove Password from Excel 2013 Using VBA Code

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.

• Click on the “File” on top right corner.
• Click on “Save As.”
• Select the folder you desire to save your document into.
• Save your file in .xls format from “Save as Type” menu.
• Click “Save.”

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:


Sub PasswordBreaker()
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)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub


• After copying the code simply paste it in the module and press “F5” to run the code.
• After the code is executed the Excel will pop up a window which will contain the new password which will be a random number.
• Click on “OK” to remove the pop-up bar and convert your file back to .xlsx format if you converted it before to .xls format.

Method 2: Remove Password from Excel 2013 with ZIP

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.

Method 3. Remove Password from Excel 2013 with Excel Password Recovery

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:

• The software consists of four password recovery types.
• The software supports all the main versions of MS Excel including 97, 2000, 2003, 2007, 2010, 2013, 2016, 2019.
• It supports all the formats and Excel file types (“.xls”, “.xlsx”).
• The software also provides trial versions to its customers.
• They also provide 30-days money back guarantee and fast online chat services.

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.

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.

Method 4. Remove Password from Excel 2013 Online (Not Recommended)

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.

• The software guarantees to remove the password from any version of encrypted MS Excel document without charging anything and free of cost.
• You will have to upload your document on their site and follow the simple instructions given.
• After it is successful you will get your documents password and use it for further purposes.
• The software provides free password recovery searching the database for 3 million passwords which is successful in 22% cases.
• If the password is still not accessible, then the software offers paid services to recover your password and searches 20 billion plus databases to recover your password. The process is very fast and only takes few minutes.

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.

Conclusion:

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.