Skip to main content
6 events
when toggle format what by license comment
Mar 11, 2022 at 19:40 comment added WoJ This is incorrect, look at @Heinzi answer.
Mar 9, 2022 at 20:58 comment added Heinzi ...On the other hand, your Google link talks about worksheets locked for editing, which even Microsoft confirms is "not intended as a security feature". Both of these features allow you to "set a password", but they are completely different w.r.t. security. (2/2)
Mar 9, 2022 at 20:57 comment added Heinzi @stevec: Unfortunately, the terminology is a bit misleading. There are multiple ways of "protecting data" in an Excel sheet. throx (and most likely the OP) is talking about file encryption, which uses strong crypto in Excel 2016 and above. ... (1/2)
Mar 9, 2022 at 12:24 comment added stevec @throx admittedly I haven't used excel in over 5 years but I thought it was possible to password protect the workbook, thus the user will be prompted to enter the password upon opening it? Is that possible? (if not, I wonder what the asker is referring to when they say the "excel sheet protected with password".)
Mar 9, 2022 at 12:16 comment added throx You're conflating cell protection (which stops a user modifying an open document) and saving a file with encryption, which uses SHA-1 keyed to AES-256. The latter, while not as good as a PKDBF style encryption is certainly nothing to sneeze at and won't be cracked by copy/pasted code. Refer en.wikipedia.org/wiki/Microsoft_Office_password_protection
Mar 9, 2022 at 10:16 history answered stevec CC BY-SA 4.0