Identifying Source Data for Pivot Tables

K

kleivakat

Is there a way to identify the source data for a pivot table? I have many
worksheets in a workbook, and several sheets containing various pivot tables,
and I would like to confirm the data source when I'm looking at a pivot
table.

Thanks for any info.
 
R

Ron Coderre

The free Pivot Play add-in, available at Debra Dalgleish's website,
displays the sources of all Pivot Tables on a worksheet.
http://www.contextures.com/xlPivotPlay01.html

(Among its features, it allows you to change the data
locations and queries of any external data sources)

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
J

jjones

While clicked somewhere within the pivot table in question, Click the Pivot
Table Wizard on the PivotTable toolbar, then press "<Back". That should show
you the data source.
 

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

Pivot tables - memory issues - please help 2
pivot table data 2
Change Data Source for Multiple Pivot Tables 1
Single Filter to change all Pivot Tables in a Workbook 8
How can I change the source data reference to another pivot table? 2
Easy way to change Pivot table source files? 5
Pivot tables - Editing the data source shared by multiple pivot ta 1
Refreshing Pivot Tables 1

Top