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.