Hi all,

I usually create a query by creating an appropriate DSN in my control panel, then choosing that MSN from MSQuery when it fires up in Excel.

The data is then returned to the sheets etc etc.

This means that each user that wants to run the spreadsheet and refresh data needs to have the correct DSN set up (same name)
Is there an alternative to this, so that end users do not need the DSN created? They can just open the spreadsheet and refresh..


Thanks in advance,
Matt