Microsoft developers’ ignorance has hit jackpot one more time. If you encrypt a sheet or workbook in Excel, the file isn’t actually encrypted (as you’d assume). Excel only places a special tag inside .xlsx file.
You can remove it in a matter of two minutes using software like Total Commander or 7-Zip. By doing so, you can gain access to “encrypted” sheet or workbook without knowing encryption key (password). Something that in theory should never happen. If we’d talk about serious encryption not “the Microsoft way”.
In previous versions of Excel (Office) that were using old .xls file you had to work with some nasty, multi-level macro to unprotect a protected file. Now they have made even easier. Instead of using some dully macros all you need is a text editor and a file to unpack and repack archive.Read More “Decrypt a sheet or a workbook in Excel”