Storing password in Excel Mac 2016 ODBC connections using embedded Microsoft Query
<p>I'm bulding an Excel Mac 2016 file that uses several connections to SQL Server using the embedded Microsoft Query service. The problem is that I'm unable to store the password in the connection: every time I open the file Excel asks for the password of every connection although it is always the same (and now I have 8 connections). No checkbox or option is displayed to store the password.</p>

<p>I've checked every option in the menus but I've been unable to find this feature. Also, I've tried to edit the connection string and adding ";PWD=" or ";Password=" but no luck. It seems to me that the login data and the queries should be separated but they are not.</p>

<p>It seems there are differences between the Mac and Windows version of Excel. Maybe this is not possible with Mac. A similar post refers to a "Use Trusted Connection" option but I can't see this on Mac.</p>

<p><a href="https://stackoverflow.com/questions/37868016/excel-microsoft-query-sql-server-login-use-trusted-connection-default-se">Excel - Microsoft Query - SQL Server login - &quot;Use Trusted Connection&quot; default setting</a></p>

<p>Thank you all in advance.</p>