Hi All,

I currently have a secondary logon ID at work.

I have created a query, in an instance of excel on my secondary ID, that mines an MSSQL database (Hope that's clear).

The above query has been saved as an add in.

I can acces this add in using excel with my primary Id but it errors and wont let me run it as it says it's accessing the database using my primary ID and not the secondary.

Is there a way of altering the connection to force it into using the secondary id?

apologies if it's not clear i did my best