title: how to hide connection string from a web query in excel
body: <p>I need to send reports to clients. The report is generated in excel via web query. The draw back is everyone has access to the excel, can see the connection string, which could be used for unauthorized access to other reports. I am considering to add password using VBA. Is there any way that I can remove/hide the connection string from connection->property? </p>