I have a slight issue.

I use excel 2016 and I have set up a URL connection to the data our business uses but whenever I do this it is changing it to an OLE DB Query. This is not a problem with other 2016 users but we have a high proportion of 2013 users still and this connection comes up with a "Failed to initialize data source" error and the user cannot refresh the data. Excel wont allow me to change this back to a URL.

Does anyone know a way to solve this so 2013 users can use the connection?