ExcelBanter - verify pivot table source

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - verify pivot table source (https://www.excelbanter.com/excel-discussion-misc-queries/65403-verify-pivot-table-source.html)

John G

verify pivot table source

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

verify pivot table source

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

All times are GMT +1. The time now is 11:08 PM.