File is password protected - but unprotect not an option

[Meredith]

Hello. I have inherited a file from a former coworker that is password protected. When I open it, it asks for a password for write access. otherwise it opens as read only. I have the password but would like to remove this protection or at least change the password.

When i look on the File>info menu or review tab, it gives me options to add protection but not to unprotect. like excel doesn't even know its password protected. Any ideas?

 

[Michael M]

Sounds like the password is being called from a macro ?
Do you have any macros in the workbook ?

 

[Meredith]

n

Sounds like the password is being called from a macro ?
Do you have any macros in the workbook ?

Nope! not a macro enabled workbook. (xlsx, not xlsm)

 

[Michael M]

HAve you tried saveing the file under a new name...then changing the password.

 

[Michael M]

Can you upload it to a hosting site, DropBox for instance, and we may be able to tke a look at it ??