Pete

You need to change the Connection property of the QueryTable object. You
may also need to change the CommandText property if it contains the path.
See here

http://www.dicks-clicks.com/excel/Ex...htm#ChangeConn

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Pete Petersen wrote:
Is there a way to switch the data source of a querry in Excel?

We have moved our reporting functions of Excel to a new server and we
want to point some old reports to that new server without recreating
the sheets. Is there a way to do that?

Thanks