Hi

I have just experienced that issue.

Solution: edit the server in the connection string of the SQL query in Excel:

Open your Excel spreadsheet,

Click in the data area (where the data should refresh, e.g. A1)

Menu > Data > Import External Data > Edit Query

click [Cancel] and click [Yes] to "Do you want to continue editing this query in Microsoft Query?"

In Microsoft Query, File > Save the query

eg: Query from Server12345_19_6_253_105.dqy

Edit this .qqy in notepad and change the server IP or Name in the connection string

don't change anything else (this time around)

Then, still in Microsoft Query, File > Open the query

(in a second window)

make sure you retrieve data with the new query (press ! )

Remove the old query by clicking the corner [X]

Quit (the open door symbol)

Back in Excel, Data > refresh data (Although it should be already doing it)

That's it. Enjoy.

Alain