I'm currently in the process of a server swap and need to refresh
hundreds of Excel documents to point to the new server.

I can change the ODBC data source quite easy (just by changing the SQL
Server, leaving the name the same). And I understand that Excel stores
this off when the query is created, that I need to refresh this
connection to repoint at the new server.

The only method I can see at the moment it to "Edit Query" on each one
and cut&paste the SQL into a new Query in MSQuery.

Is there any method to auto refresh the DataSource in the Excel? I've
had a search and have been looking at
"?Sheet1.QueryTables(1).Connection", but because the DSN name is the
same I'm not sure what I need to do to refresh this?