Someone in my office created a Pivot Table report in Excel which was driven
from a query. I cannot the query, so how can I do find what query drives
the report? If I can ever find the query and then change the query (add or
change a field) will it automatically update the Pivot Table?

And of course, if we can find the query that drives the Pivot Table can we
easily move the query and the XLS file from the client site to our office
for testing? What I understand the person in my office had to do was
develop it here then redo all the work at the client site which strikes me
as wrong.

Thanks,

Chris