Now I know that bypassing passwords is something that not everyone likes to do. However sometimes you can forget the password for a critical file or someone has sent you a file and forgotten to tell you the password to edit it.
Microsoft office's new (can I still call it that) xml based document formats have capacity for accidental write protection. Some of these include password protection. While this is great, particularly if sending spreadsheets to a customer; it isn't so great when HR send a file that needs to be edited and even they can't remember the password. That was the problem and thanks to Horatio and this Superuser answer. I was able to save the day and remove the password protection.