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

Try this. Click on the Pivot Table to "activate" it, then right click and
select "Wizard". Once in the wizard, click the "Back" button a couple of
times and it will back into the source data that the Pivot Table was created
from.

"Chris Marsh" wrote:

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

Thank you - that really helped!

"JR" wrote in message
...
Try this. Click on the Pivot Table to "activate" it, then right click and
select "Wizard". Once in the wizard, click the "Back" button a couple of
times and it will back into the source data that the Pivot Table was
created
from.

"Chris Marsh" wrote:

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