MS SQL connection that will work in Windows and Mac version of Excel Office 365.

[buchbri]

I have a spreadsheet that retrieves data from a SQL server.

I can get it to work in Windows but when I try it on the Mac it fails and when I get it working on the Mac it fails in Windows.

Is there a way to create a connection that will work in either version?

Windows has to be trusted connection = yes and on the Mac it has to be no so it can prompt for credentials.