A friend of mine today had an issue. He had created a template for some really complex calculations and to ensure he does not mess up with the forumlae by mistake he had password protected sheets and cells. He had done this back in 2012 and now he wanted change something in there but he had forgotten the password so he asked me if I can help.
Now I do not know much about how it could be done on windows or on excel but I knew a small trick on LibreOffice so I asked him to send me that excel file by email. I then took following steps:
Locked.odsfile -> Open With -> Archive Manager as shown below.
table:protected="true"and Replace All with
Locked.odsin LibreCalc and save it as
This should do the trick and unlock all password protected sheets and cells to be freely modified.