Overview

Think that your ‘protected' Excel spreadsheet is safe? Think again! These restrictions can easily be bypassed.

In this post I'll show you how to unprotect an Excel spreadsheet in a few simple steps.

Recently I had to do this when the original author of an Excel spreadsheet had left our company and no one had the password to unprotect the document.

The Approach

The XLSX format Excel spreadsheet format uses the Office Open XML file format.

Each Excel file is essentially a compressed file containing many XML format files and folders within it. The process involves unzipping the contents of the Excel archive and editing the XML files.

This might sound a bit scary but it's really not that difficult. Let me show you how easy it is…

Enough Talk … Just Show Me!

1. Rename the file extension to *.zip and open it. Alternatively you can open it directly using a zip file utility such as 7zip without needing to rename it.

File System Screenshot
File System Screenshot

2. Inside you will see many files and folders. Navigate to folder ‘xl\worksheets‘.

File System Screenshot

3. Inside here you will see an XML file for each worksheet contained in the Excel document e.g. sheet1.xml, sheet2.xml.

You will need to edit each of these xml files as per below.

4. Open each XML file with a text editor such as notepad or notepad++ and search for the text ‘sheetProtection' within the file.

Once you've found it, remove the whole XML tag i.e. <sheetProtection blah blah blah />

Save your changes.

Excel XML File Screenshot

5. Rename the file extension back to it's original state i.e. *.xlsx and then reopen the file. It should now be fully unprotected. Yay!

Final Thoughts

I hope this solution has helped you. If you have any feedback or alternative solutions, feel free to post them below to help others out there.

Happy Excel-ing!

Shane Bartholomeusz
Latest posts by Shane Bartholomeusz (see all)