I have a user who is unable to authenticate AS400 from Excel. When he tries to refresh the table, he is prompted for his AS400 password. Upon entering his credentials, it says his password is incorrect.
What we've tried so far is:
Reset the password for AS400
Checked the macro security to make sure it wasn't blocking anything
Checked the ODBC connections, which seemed to be correct
I don't know much about ODBCs, but when we checked them, we set the connection to use the windows log in (the two accounts should be synchronized) and the user was able to update the sheet successfully, but then closing and reopening Excel produced the same error.
At this point, I'm not really sure what else to look for. Hopefully one of you out there can help me out.
Thanks in advance.