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

Excel 2007 PivotTable
Unlink PTs
http://www.mediafire.com/file/myvniy2mnzm/09_23_09.xlsx

Herbert, thanks for heading me in the right direction. I could not force
Execl to allow me to name the exact same data set with multiple table names
or range names, however I was able to create multiple range names by simply
selecting additional unused columns. My tests on sample data work, now to
test on the "problem child" spreadsheet.

Thanks for getting my mind headed in the right direction!
"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
Unlink PTs
http://www.mediafire.com/file/myvniy2mnzm/09_23_09.xlsx

The crucial first step is to delete the Table name
by converting the Table to a range,
as mentioned in the instructions.
Multiple Table names for the same range
are never possible.