Hello,
I would like to determine which pivotTable(s) uses a given pivotCache.
How can I do that.
From the pivottable to the cache there is an easy way:
But I don't know the way back, since this does not work:
Anyway, how can I easily find out where a pivotCache is used?
I would like to determine which pivotTable(s) uses a given pivotCache.
How can I do that.
From the pivottable to the cache there is an easy way:
Code:
ActiveSheet.PivotTables(1).PivotCache
But I don't know the way back, since this does not work:
Code:
ActiveWorkbook.PivotCaches(1).PivotTables
Anyway, how can I easily find out where a pivotCache is used?