[5 Ways] How to Unprotect Excel Sheet without Password 2019

An Excel document can have several worksheets and it is not uncommon to find that some are protected to preserve the information on the sheet. If you have a document with protected worksheets that are unable to be edited, this article will share with you how to unprotect excel sheet without password. There are many ways to do it although some are easier and more effective than others.

How to Unprotect Excel Sheet without Password

Before discussing each solution in detail, you can make a comparison of these 5 solutions by referring to the table below and choose your preferred one.

Solutions

Unprotect All Sheets in One Click

Remove Opening Password

Risks of Data Loss

Procudures

Passper for Excel

yes

yes

100% safe to use

Very simple, unprotect in only 3 steps

VBA Code

Safe to use

Complicated, not ideal for beginners

Google Sheets

yes

Risks of data leakage

Simply, no need to install 3rd-party tool

Removing the Protection Tag

Safe to use

The procedures are very long and complex

Unprotect Excel Online

yes

NOT safe to use! Not ideal for sensitive documents

Simple to use

Now, let’s begin with the most comprehensive solution to unprotect Excel sheet/workbook if you don’t know the password.

Way 1. Passper for Excel

The best way to unprotect Excel sheet without password is to use Passper for Excel. This Excel password remover tool is designed to unprotect Excel sheet in the shortest time possible and has one of the highest success rates (100% success rate) of any similar tools. Yet, it can also help to get back opening password on an Excel document, allowing you to easily open the document that is otherwise locked for reading. It is easy to use with a friendly and simple to navigate user interface.

Passper for Excel is secure and simple to use. It has been highly recognized by a great many famous sites such as Cult of Mac, Makeuseof, Macworld, Payetteforward, etc.

part of tech sites

Windows version

If you need to know how to unprotect excel sheet without password using Passper for Excel, download and install the program on to your computer and then follow these simple steps:

Step 1: Launch Passper for Excel on your computer and then select “Remove Restrictions” from the two options in the main window.

choose remove restrictions

Step 2: Click “+” to import the password protected Excel document into the program. Once the document is open, click on “Remove” to unprotect the Excel sheet.

all excel sheet

Step 3. In just a few seconds, Passper will unprotect the Excel sheet and your document will be editable.

remove restrictions

Way 2. Via VBA

You might also be able to use VBA code to unprotect Excel sheet without password. This method has long been a popular way to unprotect Excel file when you don’t know the password. Here’s how to do it:

Step 1: Open Microsoft Excel and then press “ALT + F11” on your keyboard.

Step 2: Under the “General” section of the window that appears, enter the following code without changing anything:

excel vba code

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

Step 3: Press “F5” on your keyboard to run the code and you’ll see a dialogue box with the password in a few seconds. You can use the password to unprotect the document.

Things you should take note of:

  • VBA code can only be used to unprotect a single sheet. For 2 or more protected sheets, just repeat the steps above.
  • It doesn’t support the Excel versions later than 2010. For Excel 2010 and later versions, you should save them as Excel 97-2003 first.  

Way 3. Using Google Sheets

If you don’t have the password for the protected Excel sheet, you may be able to use Google Sheets to unprotect Excel sheet without password. Follow these simple steps to do it:

Step 1: On any browser, open your Google Drive account and sign in with your Google account. Click on “New

and then select “Google Sheet” to open a new Google Sheets document.

import excel sheet

Step 2: Click on “File > Import” and then click on “Select a File from your Device”.

select a file from your device

Step 3: Locate the Excel document with the protected sheets on your computer and then click “Open”.

Step 4: Now click on “Replace spreadsheet” and then select “Import Data”.

replace spreadsheet

Once all the data on the Excel document is imported to Google sheets, the sheet will no longer be protected. You can continue to edit the document in Google Sheets or download the sheet from Google drive to edit in Excel.

Way 4. By Removing the Protection Tag

You can also easily remove the protection tag, a factor that will instantly unprotect the Excel sheet. Here’s how to do that:

Step 1: Locate the Excel document in Windows Explorer and change the file extension from .xlsx to .zip.

change excel name to zip

Step 2: Now open the .zip file using an archive program and find the workbook.xml file.

open xml with archive program

Step 3: Open this file in Notepad and then locate the tag that begins with <workbookProtection…/>.

delete protection tag

Step 4: Delete the whole tag and then save the file. Change the workbook’s extension back to .xlsx and the worksheet will be unprotected.

Way 5. Unprotect Excel Sheet without Password Online (Not Recommended)

Thanks to cloud computing, there are several online tools such as password-find.com that might be able to help you unprotect the Excel sheet/workbook. Typically, you have to upload the workbook onto the online tool’s server and then the tool works to remove the restriction. While these tools are typically effective, uploading the document to the server might not be safe. You never know if the program will keep a copy of the document after the process. This method may therefore not be ideal for more sensitive documents and should be a last resort.

unprotect excel sheet online

Bonus Tip: Unprotect Excel Sheet with Password

Here’s how you can unprotect Excel sheet from Microsoft Excel if you remember the password:

Step 1: Open the Excel document with the protected sheet and then right-click on the tab for the protected sheet (the tabs will appear at the bottom of the page and the protected sheet will often have a padlock on it).

Step 2: Select “Unprotect Sheet” from the list of options presented. If the sheet is not password protected, it will unlock immediately. If it is password protected, you will be prompted to enter the password before you can unprotect the worksheet.

unprotect excel sheet with password

Step 3: If you need to, enter the password and click “OK” to complete the process.

Now you have various effective ways to unprotect Excel sheet without password. Choose the method that will best work for you based on your circumstances and the nature of your document. If you have any questions or comments about this or other related topics, use the comments section below to reach out to us and we’ll do our best to help.