Shot Myself in the Foot

[BobH]

Somehow, I managed to protect my electricity usage workBOOK with a password that I don't remember. I'm sure I fat fingered something, but no matter how many combinations of spelling the password that I use - and have stored so I can copy and paste it - I cannot un-protect it.

If you have a better recovery strategy than mine, please tell me. My strategy is to create a new workbook for the data and to copy each workSHEET from the protected workBOOK and paste it into the new one. There are a few dozen months of worksheet data. The process is quite tedious because I have to use Special Copy to preserve the formats, formulas and values for each.

Any help shall be greatly appreciated and gratefully received.

[HansV]

Is it a .xls workbook, or a .xlsx/.xlsb/.xlsm workbook?

[hamster]

maybe attach this file here...
hope this is xlsx or xlsm

[BobH]

the file is .xlsx - office 2016 pro

[hamster]

but where is attached file?

[BobH]

I get the message that the file is too large to attach. It's 321mb

[hamster]

use onedrive or googledrive and share it without any login or password and post link here

[snb]

Wouldn't Open Office help ?

[robertocm]

Try this:
https://www.xarcom.net/blog/quitar-cont ... nto-excel/

Or this:
http://www.taringa.net/posts/hazlo-tu-m ... asena.html
https://stackoverflow.com/a/33826094