Forum Discussion
How can I unlock an Excel spreadsheet that is locked for editing?
bill-xu I renamed the .xlsx to .zip and managed to find the sheet1.xml from /xl/worksheets/. And only one .xml under this folder.
However, when I opened sheet1.xml file, there is no tag named sheetProtection. Only a sheetView tag shows up.
P.S. This xlsx file was created by Excel 2019.
this becomes a little complicated...
there may be a tag has two attributes "algorithmName" and "hashValue", the tag's name could be "sheetProtection" or something else depending on the protection mode (maybe?).
you can backup your file first and make a try.
please note, excel workbook contains blob (binary data) in zip file which is not able to be repacked.
so don't decompress its contents into flat files, just use zip tools to edit the file.
winzip, 7zip, etc. can help you replace file inside a zip file without repacking it. (mean just dragging a file from outside into the zip file)
here is a link about ms open spec for office documents in which sheetProtection is explained.
https://learn.microsoft.com/en-us/openspecs/office_standards/ms-oi29500/15197a02-26f7-4a37-ab9c-7de4d4894ea5