Hi Tony,

"TonyL" wrote:
How do I find out where the data source is located from the query? I
figured that when I find the data file I will change the filename & run the
query & it will come up with an error & allow me to point to the correct data

Try running this bit of macro to give you the connection string in Sheet1!A1:

Sub FindConnection()
Sheets("Sheet1").Range("A1").Value = Sheets("Your query
sheet").QueryTables("Your query").Connection
End Sub

/Sune