Multiple pivot Tables, do not share changed group name

[kourampies]

Case:

Suppose I make two pivot tables based on the same source data. (both tables use the same data cache).


If I make a group in the one table, the same grouping appears in the other table as well.(so far so good)


Problem:

If I try to rename the default name "Group 1" in the pivot table1, the new name does not change in pivot table 2(The group name remains "Group1"


Any ideas on how to have common group names between multiple pivottables that share the same cache???


Thank you in advance

V.

 

[NARAYANK991]

Hi ,


This appeared in the link given below :


QUOTE


Grouping in One Pivot Table Affects Another


If you create two pivot tables based on the same Excel Table in Excel 2007, when you change the grouping in one pivot table, the same grouping appears in the other pivot table.


Because you created the two pivot tables from the same source data, by default they use the same pivot cache, the grouped items are the same in both tables.


To use different grouping in each pivot table, you'll need to create a separate pivot cache for each pivot table.


Use the following method, suggested in the Excel newsgroups by Dave Peterson.


To create a separate pivot cache for the second pivot table:


Cut the second pivot table, and paste it into a new workbook.

Change the grouping of the second pivot table.

Cut the second pivot table from the new workbook, and paste it back into the original workbook


UNQUOTE


http://www.contextures.com/xlPivot07.html#Another

 

[kourampies]

Thank you for the answer but it does not address my problem...


"Because you created the two pivot tables from the same source data, by default they use the same pivot cache, the grouped items are the same in both tables. "


I do want the same groups in the tables, but if I RENAME a group in one table this name DOES NOT PASS to the other table.

 

[NARAYANK991]

Hi ,


Sorry I did not get it.


Narayan

 

[Collock]

As long as you are not using the same name anywhere else in your tab(s) were the tables are, use find and replace.

 

[fred]

instead of using generic group name, kourampies. try using generic name such as "dragon", "tiger", "leopard", etc but not group1, group2.


I also encounter the same issue you might have raise. If I "group" 1 and 3 on PVT #1 and name it "Peter". I can do that, no problem.


However, if on PVT #2 created I tried to "group" 1 and 2, the original group "Peter" on PVT #1 would be defaulted back to Group1.


So it seems to me that you can only group the same thing on both PVT and name them differently. But if you try to re-group even just one element on either PVT that's already part of a certain group, the group you have created before hand would reset.


All in all, I can group 1 and 3 and name them "Peter" on on PVT; Group 1 and 3 and name it "Paul" on the 2nd PVT. But if I group 1 and 2 on PVT#2, "Peter" would be gone. Excel just won't let me have my way of custom grouping 1 and 3 with a unique name together with 1 and 2 on another pvt.