Pivot Table Data Source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
(e-mail address removed)


Kirk P. said:
I have several tables that use various queries stored in Access as the
Click to expand...
data source for my Pivot Tables.
Question is, after the Pivot Table is set up, is there any way to
Click to expand...
determine what the data source is?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identifying Source Data for Pivot Tables 2
Pivot tables - memory issues - please help 2
How can I change the source data reference to another pivot table? 2
pivot table data 2
Pivot tables - Editing the data source shared by multiple pivot ta 1
Pivot Table Data Source 1
Pivot table change data source 1
Column limit for Pivot Table data source 1

Back
Top