You need to look in the Connection property of QueryTables and
PivotCaches. Sometimes you also need to modify the SQL property of
QueryTables since there is a tendency to include the name of database
files in the SQL, but probably not in this case as it is a real server.

If you need it I can supply a utility that will modify such properties.
EMail me at Bill _ Manville @ compuserve . com (without the spaces)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup