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

buchbri

New Member
Joined
Jul 29, 2019
Messages
1
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.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,102,554
Messages
5,487,527
Members
407,604
Latest member
sama9000

This Week's Hot Topics

Top