Recently, at work, we have faced an issue where we want to resurrect one of the old Excel files and we found out that, when a file on its own can be opened without any problem, some options, like Workbook Structure or individual Sheets been protected with a password.
The problem was that the person, who initially create the file, was no longer with the company and nobody knew what password was used. As we were able to open the file on its own, as it wasn’t protected, knowing about how XLSX (also XLSM) files are constructed, I decided to use the brute method to remove restrictions.
Here’s how it goes…