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?
Bookmarks