Ask Your Question

Password lost

asked 2018-03-29 17:35:03 +0100

Peter Watt gravatar image

I have inadvertantly set a unintended password on a spreadsheet page and cannot unlock the sheet. How can my sheet be unlocked? Thanks

edit retag flag offensive close merge delete


Are refering to the spreadsheet file or a single sheet in the spreadsheet?

m.a.riosv gravatar imagem.a.riosv ( 2018-03-29 18:25:30 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-03-29 18:35:11 +0100

erAck gravatar image

If it is not a password to encrypt the document (in which case there's nothing but brute force trying all possibilities) but only a password to protect a sheet, then it is more or less only a flag in the document that can be removed. It depends on the document format. In an .ods zip file it is in the content.xml file's element table:table, remove the table:protected and table:protection-key and table:protection-key-digest-algorithm attributes and freshen the .ods zip with the modified file. In an .xlsx zip file it is in an xl/worksheets/sheet*.xml file, remove the entire <sheetProtection.../> element and freshen the .xlsx zip with the modified file. If this is all mumbo-jumbo to you ask someone who can do it for you.

edit flag offensive delete link more


Thanks for a detailed explanation.

m.a.riosv gravatar imagem.a.riosv ( 2018-03-29 23:24:58 +0100 )edit

Now also available as FAQ.

erAck gravatar imageerAck ( 2018-10-25 17:49:14 +0100 )edit

Nice having a reference place.

m.a.riosv gravatar imagem.a.riosv ( 2018-10-25 19:52:50 +0100 )edit

answered 2018-03-29 18:10:49 +0100

ajlittoz gravatar image

You have a very long discussion here explaining why it is impossible.

But, in the same thread, you'll find a macro trying to guess what the password is, provided some favourable circumstances are met. Have a try but success is not guarantedd.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-29 17:35:03 +0100

Seen: 2,926 times

Last updated: Mar 29 '18