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.....
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!