I setup a new domain user on a Windows 7 Pro 64bit workstation, Office 2010. User is a local administrator. When he tries to open Excel files that have been password protected within Excel, the password will not work. Log in as the old user and it works. I also copied the .xls file to my PC and it will not take the password.
I know I could probably unprotect them as the old user, then protect them again as the new user. But he has lots of password protected files, so that would be time consuming. I've also never seen this behavior before where somehow a file protected within Excel is also somehow tied to that user.