MoonPoint Support Logo


Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals

Advanced Search
Sun Mon Tue Wed Thu Fri Sat

Tue, Nov 15, 2016 10:50 pm

Unprotecting an Excel workbook when the password is not known

If you are unable to insert new worksheets into an Excel workbook or make other changes to the workbook because it is protected and you don't know the password to unprotect the workbook, if the workbook is in a .xlsx file, you can remove the password by changing the .xlsx file extension to .zip, then extract the contents of the zip file, locate the workbook.xml file within it and remove the password between the double quotes following workbookProtection workbookPassword= using a text editor, then resave the file and recompress the directory produced when you unzipped the zip file, but, on an OS X system, you will need to ensure that the directory and its contents are compressed in the way Excel is expecting, e.g. with the zipdir Pyhon script.

[ More Info ]

[/software/office] permanent link

Once You Know, You Newegg AliExpress by

Shop Amazon Local - Subscribe to Deals in Your Neighborhood

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo