Pivot Tables linked both changing

[Gary E Smith]

I currently have 2 pivot tables linked to the same base data .
The problem:-

When I change the grouping on one pivot table it changes on the other what am I doing wrong?

 

[RoryA]

What exactly do you mean by 'grouping'?

 

[Gary E Smith]

When I am in a pivot table i choose a couple of rows then right click and group.

This grouping appears on both Pivot tables ??? Really wierd did not do this in excel 2003

 

[RoryA]

Which version are you using now? 2007?

 

[Gary E Smith]

Example

create 2 pivot tables from same data same layout

set up row grouping on one pivot table

then

try to set up different row grouping on the other pivot table

 

[Gary E Smith]

2007

 

[RoryA]

When I do that in 2003 with 2 pivots based off the same data, the grouping in one affects the grouping in the other, which is what I would expect. That's assuming I group the fields as opposed to grouping the entire rows.

 

[Gary E Smith]

I must have had a mental aboration thank you for your paticience

 

[RoryA]

No problem - I have them all the time!

 

[bepeco]

I'm having the same problem too, but I need a workaround to stop this behaviour. I have a bank statement in a table of data, following transactions in and out of a bank account. From that table I need to be able to summarise the data into both monthly and daily quantities, to produce different charts. I have used the table as the basis for two PivotTables.

In one PivotTable, I have grouped them into monthly summaries, and in another I need them broken down by day. When I group one, it groups the other. I've tried inserting a new PivotTable but they are still linked. Is there a way of unlinking the two?

Any help is much appreciated.

Ben