How to unprotect a password protected .XLSX file
Posted by Adam
Oct 5 2011
I found a pretty easy way of disabling the password protection in the new Excel Worksheet files (XLSX) used by Excel 2007 and 2010. Just follow these simple steps:
- Change the file extension from .XLSX to .ZIP
- Extract the file to a folder with your favorite unzipper (7-Zip is what I used)
- Go to the xlworksheet sub-folder that you just extracted
- There should be one or more files named like: sheet1.xml (sheet2.xml, etc). Inside of one of those files is an XML tag: <sheetProtection password=… />. Delete that entire XML tag.
- Re-zip the files back up
- Rename from .ZIP to .XLSX
Done!
UPDATE: This method only applies to password protected workbooks. If the file is secured with the “Encrypt with Password” feature, it will not work.
Related Posts:
Changes in registry startup key between Windows XP and… February 6, 2013 Several days ago I had an issue reported where one of my applications was causing a strange folder to open…
Installing Windows 7 on an HP p2-1334 Desktop PC October 31, 2012 I had so much trouble getting Windows 7 to load on the HP p2-1334 Desktop PC. The only OS option…- SGEN: An attempt was made to load an assembly with an… October 12, 2012 While I was setting up a new build server, I ran into a problem where I would receive the error…
15 Comments
→
Thank you!
I’d like to also recommend who follows these steps to check that all the files are kept on the zip’s root instead of a folder or else it won’t work.
Hello,
i followed these steps,
1. .xlsx to .zip
2. extract to a folder with 7zip
3. but i got
[6]DataSpaces (Folder)
EncryptedPackage (File)
EncryptionInfo (File)
Unable to find this folder (Go to the xlworksheet sub-folder that you just extracted)
Help me
Thank you
Sibi
Merci from France
Chellapandi, apologies, it seems that this tutorial only applies to Protected Workbooks (not the “Encrypt with Password” option). I will update the post to reflect that.
I was able to follow the directions up to “re-zip the files back up”. I don’t know how to do this step. I also downloaded 7-Zip but no luck in trying to figure it out.
Amy, you should be able to go to the folder (where you extracted the contents of the .XLSX file), select all the files, and then right click and in the 7-Zip sub-menu select “Add to Whatever.zip”. After that rename it from Whatever.zip to Whatever.xlsx (replace “whatever” with the name of your file).
Worked for me… thanks for the tip!
couldn’t find the keyword, doesn’t work for me
This technique only works if the workbook is password protected. There is another Excel features called “Encrypt Spreadsheet with Password” and this does not work for that option. Are you sure you’re looking at the right thing?
Worked like a charm. People using sheet protection only probably don’t know how easy it is to hack.
Hi Adam: For some reason, the workbook I’m trying to open doesn’t seem to have even the characters ‘Prot’ in any of the XML files. The workbook has 17 visible worksheets and 5 invisible worksheets for a total of 22 XML files. Any tips?
Cannot unzip, says it’s not a valid zip file
Great it’s work …. thanks
thks,… great
thank you! it worked for me…