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.

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.

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.

"kleivakat" wrote:

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.