Create Backwards Compatible SQL Server data connection in Excel 2016

I've recently been upgraded to Excel 2016.

However I'm now finding that data connections I create to our SQL Server database cannot be refreshed by users with Excel 2013.

Is this a known issue? Is it something I can do anything about?

I am now creating the connection as follows:

1. Data / Get Data / From Database / From SQL Server Database
2. Entering server and database details
3. Clicking Advanced then entering SQL code into the SQL statement box
4. Clicking OK

Is there another way which will enable those XL2013 users to refresh the query, perhaps?

Thanks in advance. C

I found an answer, in case anyone's interested. There is an option in Excel 2016 (Office 365 subscribers only - see note below) to show the legacy import wizards.

So, if you know your users have older versions of Excel you can enable legacy wizards (see below) and set up data connections that way.