I have a critical problem in AS400 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 MSOffice 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.
(1) 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.
(2) 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 radiculous.
Please let us know what is the mystery behind it.
Shailesh Mahajan (Section Manager-MIS)
BRIDGESTONE INDIA PRIVATE LIMITED
Pithampur, Distt Dhar
June 7, 2008 4:08 AM
April 25, 2010 10:03 AM