View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nadine nadine is offline
external usenet poster
 
Posts: 216
Default Copying pivot table

Hello,

I have made a pivot table containing the ages of the employees in our firm.
I thus have a pivot table with all the ages (ex. 20,21,22 etc) for both men
and women. I would like to group the ages say by tens and have copied the
pivot into a new worksheet. So far so good, but when I now group the ages,
this grouping is also shown in the original pivot table! I already tried
copying only the pivot table and copying the entire worksheet but the result
is the same. Could anyone help me with this please?