How to find the current pagefield of a pivot table?
Hi,
When selecting a pivot item from a pagefield of a pivot table, how can one
programmatically get the name of the page field without having to know the
name of the page field?
My problem is this: I have 4 pivot charts on a worksheet having the same
page, row and column fields. (They only differ in Data fields). I am trying
to implement in VBA the behaviour that when a page field is changed in one
chart the same page fields are automatically changed in the other 3 charts.
Thanks
Tama
|