Pivot Table Data Source

[Kirk P.]

I have several tables that use various queries stored in Access as the data source for my Pivot Tables.

Question is, after the Pivot Table is set up, is there any way to determine what the data source is?

 

[Nick Hodge]

Kirk

Click anywhere in the pivottable and invoke the pivot table wizard but
instead of going forward press the back button and you will get a button
with 'get data' on it, this should start with the location of the current
data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]

I have several tables that use various queries stored in Access as the

data source for my Pivot Tables.

Question is, after the Pivot Table is set up, is there any way to

determine what the data source is?