Unprotect Excel Sheets Without Password

https://www.youtube.com/watch?v=oq59u0rpkiE

It’s not uncommon for many people to protect worksheets in their Excel files and then forget the password.

It has happened to me many times, and every now and then, I have people sending me their Excel files asking how to unlock the sheet without the password.

The good news is that Excel password protection is not very robust, and you can easily get around it.

You do not need any third-party software or website to do this. You can do it right there on your computer or laptop in less than a minute.

Let’s see how to unlock Excel sheets without knowing the password.

Click here to download the example file and follow along

For this article, I am going to use one of the Excel Dashboard files I created called Call-Center-Dashboard.xlsx. It has three sheets, and all the sheets have been protected with a password.

If I try to make any change in the worksheet, I get a prompt as shown below:

Prompt went trying to change protected worksheet

Let’s now look at the steps that will unprotect a sheet even when you don’t have the password.

Step 1 – Make a Copy of your Excel Workbook (Highly Recommended)

While this is not a mandatory step, I highly recommend you create a copy of the Excel workbook from which you want to remove the worksheet protection.

Since we are going to temper with the code that makes up the Excel file, there is a possibility that things may go wrong, leading to the corruption of your Excel file or loss of data.

In my example, I will make a copy of the file Call-Center-Dashboard.xlsx.

This copied version of the file is named Call-Center-Dashboard-Copy.xlsx

Make a copy of the file you want to unprotect
Make a copy of the file

Step 2 – Change the Extension of the Workbook to ZIP

The next step is to change the extension of the file (in which you want to unprotect the worksheets) from .xlsx to .zip.

You will see a Rename dialog box as shown below. Click on Yes.

Prompt when changing Excel file to zip

Doing this will convert your Excel file into a zip folder, allowing you to access different worksheets separately.

Excel file converted into zip folder by changing the extension

In my example, I will change Call-Center-Dashboard-Copy.xlsx to Call-Center-Dashboard-Copy.zip

If you don’t see the file extension in your Excel workbook, click on the View tab and make sure the File Name Extensions option is checked.

File Name extension to be visible

Step 3 – Locate the Worksheet XML File and Open in Notepad

Now, double-click on the zip folder to open it. You should see a couple of folders as shown below.

Folders inside the ZIP folder

Open the XL folder, which will show you more folders, as shown below.

Folders inside the xl folder

Open the Worksheets folder, which will then show you all the sheets in your Excel file as XML files.

Sheets as xml files inside the worksheets folder

In my example, I have three worksheets, which are shown as XML files.

Copy the sheet from which you want to remove the password, come out of the ZIP folder, and paste this file.

In this example, I will copy sheet3.xml file and paste it outside the zipped folder.

Copy Sheet xml file outside the ZIP folder

Since I need to make changes to this XML file, I cannot do this inside the zipped folder without extracting it. So I copied the file and pasted it outside the zip folder so I can make changes to it, and once I’m done, I can copy it back into the zip folder.

Step 4 – Remove the Worksheet Protection from the code

Now that we have the XML file outside of the zip folder, we can make changes to it and remove the worksheet protection.

Right-click on the XML file and open it with a Wordpad or Notepad.

Open XML file in wordpad

This will show you the code as shown below:

Code inside the XML file

Use Control + F to open the Find dialog box and search for the word ‘protection’.

Search Protection in the code

This will take you to the part where the code says sheetProtection.

Select the entire code starting from <sheetProtection till the closing bracket >.

Delete this code and save the file.

Delete the sheet protection code

The above steps have removed the worksheet protection from the worksheet. But we still need to put it back in the zip folder and convert the zip folder back into an Excel book.

So copy this XML file, Go back into the zipped folder –> xl folder –> worksheets folder, and then paste the file back.

Since the folder already has a file with the same name, you can first delete the original file and then copy the file where we have made changes in the code.

Step 5 – Convert the ZIP Folder Back into an Excel Workbook

Come out of the zip folder and then change the extension from .ZIP to .XLSX

And that’s it!

Now, if you open the Excel file, you will notice that the protection has been removed from Sheet 3.

In this example, I have shown you how to do this for one sheet only, but you can repeat the same process for all the sheets that have protection that you want to remove.

And as mentioned, you didn’t need to know the password to unprotect the worksheet, as we were able to go into the code and remove the entire part that was responsible for protecting the sheet.

Use Responsibly: While Excel protection is not very robust, and it’s quite easy to break worksheet protection without passwords, make sure you’re using it responsibly on either your files where you have forgotten the password or other people’s files where they ask for your help. Don’t use it to steal someone else’s work or unprotected worksheets that you’re not supposed to tamper with.

In this article, I showed you how to unprotect worksheets where you do not remember the password.

I hope you found this article helpful. If you have any questions or suggestions for me, please let me know in the comments section.

Other Excel articles you may also like:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster