I'm working on a macro that creates several pivot tables using the same pivot cache. All the tables use the same page-, row-, and column fields, only the data fields are different in each table.
How could I make sure that if the user changes one of these fields on any of the tables, all the other tables do the same changes (=all the fields in the other tables change as well)?
I'm using the different pivot tables to draw different charts (not Pivot charts but regular charts). The charts use the column fields as labels & row fields as series. -What would be the best way to make sure that if the user adds another row-/column field (they all start with only one row / column field) the new fields appear in the chart labels/series as well?
How could I make sure that if the user changes one of these fields on any of the tables, all the other tables do the same changes (=all the fields in the other tables change as well)?
I'm using the different pivot tables to draw different charts (not Pivot charts but regular charts). The charts use the column fields as labels & row fields as series. -What would be the best way to make sure that if the user adds another row-/column field (they all start with only one row / column field) the new fields appear in the chart labels/series as well?
