An aggravating issue with pivot tables,I have a bunch of Pivot tables on
different tabs referencing the same table.
The problem is when I refresh 1 pivot table, excel refreshes all the pivot
tables and removes the grouping on all the tables.
I dont mind the all refresh, but I do mind the removing of the groupings (I
group by day, month, year) on all the tables.
So how can I do the following:
1. Remove the dependence between the pivot table so that changes to one
doesnt affect the others- when I group on pivot table it groups all the
other pivot tables.
2. I have the €œpreserve cell formatting on update€� box checked, but why is
the grouping being removed on update? I want the formatting (i.e. the groups
and the collapsed dates) to remain in place even when I update. I have about
a dozen different tabs and each time I refresh I have to go to each tab and
collapse down to the view I left it on€¦

Any and all suggestions will be appreciated