HELP....I series Client access and Excel

[Sarasotason]

I have a large workbook with imbedded data transfer macros using ODBC to a
AS400 , the client pc is running I series client access. The problem is the
400 is now using Kerberos and the Excel prompts for ID password that the
user no longer has. The user name is the last person to have successfully
connected, so I know it is coming from the excel workbook... Looking for a
way to stop the workbook from remembering log on and use the Kerberos as the
ODBC driver is set to use. HELP this work book is a monster of macros and
formulas not something that can be easily recreated.

 

[Bill Manville]

How is the data being transferred into the workbook?
By a QueryTable (Data > Get External Data) or a PivotTable, or by code
using a recordset connection to the database?

You should only need to change the Connection property that is being
used - but we need to know where to look to find it.

Bill Manville
MVP - Microsoft Excel, Oxford, England