Open the Excel workbook, select Data, Get Data, Data Source Settings,
click on the setting you need to change, then Edit Permissions.
Credentials - Edit and you should be able to see the saved user name and
password you want to change.
I have an Excel file that uses queries to pull data from the iSeries. The user ID seems to be stored somewhere for a particular user, but default. Where are these credentials stored? Are they hidden in Excel somewhere? I didn't create the Excel file, it was created years ago by a power user, no longer with the company.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
