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)
"kleivakat" wrote in message
...
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.