I have a critical problem in AS/400 data fetch query in MS Excel (Petch SP2 loaded).
I have created several Excel Sheets (in MS Office 2003) for fetching the data from AS400 using MS Office Query option under Data-->> Refresh Menu.
Those excel sheets are using by so many different users on their desktops.
I have the following problems/doubts in those Excel sheets.
Same Excel sheet which is created on my PC and forwarded to the 2 different users are behaving differently like in My PC while doing Data-Refresh, doesn't prompt for user/password but on different PC it prompts.
Even if i understand that my user name and password has save somewhere in my PC then another Excel sheet which is created on different machine and forwarded to me and then when I try to do Data-Refresh on this sheet it is prompting the User/Password, which indicates that the User/Password saves somewhere may be in Excel sheet also .
I have tried several ways to resolve the issue, but still the problem persists.
How I can set the Default User in the Excel Sheet.
I have tried with so many options like change the default user in Operation navigator, change the REGEDIT also, and so on.
But still I didn't get any solution on the above problem. I have created the excel sheets where the Excel sheet fetch the data almost 20 to 30 times. Therefore the user has to supply the user/password 20-30 times which is ridiculous.