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.....
February 2, 2005 10:30 AM
February 4, 2005 4:10 PM