Bypass username/password prompt when executing an excel web query

Hello,

Can anyone tell me plz how to Bypass username/password prompt when executing an excel web query. I want other users to be able to run that from excel and I don't want to provide them my password or username. Thank you

I take it you're on a network, if this is the case then the person opening the web query needs their own access rights to the internet or intranet, if they have then they will be able to execute the query no problem.

Regards,
Simon