Test

Test

Recent Posts

  • Top 5 Best Windows 7 Password Recovery Software
  • How to Remove Password from Excel 2007 if forgotten
  • How to Remove Forgotten Password From Excel 2016
  • How to Show Administrator Password Using CMD in Windows 10/8/7
  • How To Unprotect Excel Sheet Without Password 2013
  • Time Limited Offer: Get $20 OFF  for Windows Password Recovery Advanced  Get It Now >>
WinPassKey
  • User Guide
  • Compare Editions
  • Try It Free
  • Buy Now
English
  • Deutsch
  • Español
  • Русский
  • Français
  • 日本語

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

  • Home
  • How-to Articles
  • Excel Password Tips
  • How to Remove Password from Excel 2013 If I Forgot My Password
How to Hack Windows 10 Admin Password
November 26, 2019
How to Remove Password from Excel 2010 without Knowing Password
November 28, 2019

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.”

Convert the xlsx File 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.

Open the Visual Basic Editor

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.

right click on Project-VBAProject

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.

add new module in VBA

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.

change the name to zip

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:

excel code in zip

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.

Free Download Buy Now

Step 2: Open the file which you want to recover the password from and insert it in encrypted file box.

add locked excel file

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.

excel password recovered

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.

Free Download Buy Now
Share
0

Related posts

December 6, 2019

How to Remove Password from Excel 2007 if forgotten


Read more
December 6, 2019

How to Remove Forgotten Password From Excel 2016


Read more
November 30, 2019

How To Unprotect Excel Sheet Without Password 2013


Read more

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Hot Tips & Tricks

  • Top 5 Best Windows 7 Password Recovery Software
  • How to Remove Password from Excel 2007 if forgotten
  • How to Remove Forgotten Password From Excel 2016
  • How to Show Administrator Password Using CMD in Windows 10/8/7
  • How To Unprotect Excel Sheet Without Password 2013
  • How to Remove Password from Excel 2010 without Knowing Password
  • How to Remove Password from Excel 2013 If I Forgot My Password
  • How to Hack Windows 10 Admin Password

Factory Reset Without Password

  • How to Reset Samsung Laptop to Factory Settings without Password
  • How to Reset ASUS Laptop to Factory Settings without Password
  • How to Reset Acer Laptop to Factory Settings without Password
  • How to Factory Reset HP Laptop without Password
  • Restore Gateway Laptop to Factory Settings without Password
  • Factory Reset Lenovo Laptop without Password

WinPassKey

Windows Password Recovery is the world's first Windows Password Recovery Tool to reset lost/forgotten password for Windows 11/10/8/7/XP/Vista and Windows server 2000 /2003/2008/2011/2012/2016.

  • Buy Now
  • Free Download
Secured by MacFree

Change Language

  • English
  • Deutsch
  • Español
  • Français
  • Русский
  • 日本語

Hot Searches

  • Kon Boot Alternatives Free Download
  • How to Break Windows Administrator Password
  • How to Use Ophcrack on Windows 10
  • Delete Administrator Account in Windows 7
  • How to Bypass Windows 8 Password
  • How to Bypass Windows 10 Password
  • Hiren’s BootCD 16.2 ISO Free Download
  • How to Reset Windows 10 Password

Hot Tags

  • How-to Articles
  • Windows 10 Password
  • Windows 8/8.1 Password
  • Windows 7 Password
  • Laptop Password
  • Windows Tips
  • Windows XP/Vista Password
  • Other Password Tips

Company

  • About Us
  • Privacy Policy
  • Terms & Conditions
  • Sitemap

New Product

  • Password Recovery Bundle
  • Product Key Finder
  • Windows Data Recovery
  • Word Password Recovery
  • Excel Password Recovery
  • RAR Password Recovery
  • ZIP Password Recovery
  • PDF Password Recovery
Copyright © 2007-2019 Windows Password Recovery. All Rights Reserved.
English
  • English
  • Deutsch
  • Español
  • Русский
  • Français
  • 日本語
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok