Easiest way to unprotect Workbook or Worksheet without password

Looks like there is a bug in new Excel dealing with old Excel files
Tried that several times and it worked every time, it did actually remove the password for protected view of Worksheet and Workbook, it did not remove the protection, just the password.
So, If you have xlsx or xlsm with Workbook view or Worksheet view protected, do the following:

  • Save it as xls
  • Save it back as xlsx or xlsm
  • Now try to unprotect workbook or worksheet


The password just, Gone! with the wind

Posted on Linkedin here
https://www.linkedin.com/pulse/easiest-way-unprotect-workbook-worksheet-without-password-amdeen
excel pc programming cybersecurity protection linkedin