Connection Issues, Excel To Access Query, Access 2010

Hello everyone,
Using Excel and Access 2010..
I have created a connection from Excel into and Access Query using the "from other sources\from Microsoft query" option. (Images ConnectionType and ConnectionType02)
This then pulls in data from an access database query and Excel uses this data to formulate figures and produces charts accordingly.
Works brilliantly on my laptop (Excel) into our work terminal server (Database)

The Problem;
When I place the excel worksheet onto the Terminal server for the company to use, I get Connection errors. (Images ConnectionError01,02,03).
Majority of staff are using an RDP type set-up to connect into the terminal server. We have a multi site company.. lets not go there why its set up the way it is.
The terminal server is using Excel 2010 and Access Runtime for the Access programs.
I split the database into a front end and a back end and save the front end as a .accde file.
Can I please get assistance to rectify this connection issue so I can appease the powers that be and they can use what I have created.

I have created a macro command button on the spreadsheet which fills in some cells with dates and then calls the refresh all data function to activate the query connection.
Appreciate the help.