You can see if the pivot tables use the same pivot cache. There are
instructions he

http://www.contextures.com/xlPivot11.html

John G wrote:
how do I verify that a pivot table source is another pivot table in the same
excel file? I have lots of tables that use the same source.
Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html