I am creating Excel spreadsheets that are populuated with data from the AS/400. When I perform the refresh data option from inside Excel from my PC, it works properly. When I forward the spreadsheet to a user, the ODBC window pops up asking that the password be entered for my USERID.
It should use the cached user USERID and password. I have changed the ODBC link from the users PC but the prompt still appears.
Thanks in advance for your help.....
We are using USER DNS. Even if the user is already signed onto the AS/400, it prompts for USERID and password with my USERID as the default not the user signed onto the system.
Discuss This Question: 2  Replies