Excel 2007, multiple PTs based on same dataset/cache, combining rows into
grouped rows with unique group names. Need to update PTs weekly, and
groupings change as a result of changes in dataset (the calculations update
as expected with the new dataset). Is there anyway to have the unique
combined row names represented in all PTs without having to copy from a PT
where the grouping changes are made and rebuilding the other PTs manually
(copy/paste/rebuild)? The grouping names are obviously not beeing kept with
the cache (just Groupxx). The unique grouped row names copy appropriately
the first time the cloned PTs are made, but are then static.

Thanks in advance,

J Austin