Hi

When you create your PT's you are using the same Pivot cache for each of
them, hence you will see this behaviour.

If you choose the option not to use an existing data set (to save space)
when creating subsequent PT's, each will have its own cache and any
groupings will be independent.

--
Regards
Roger Govier

"Bunji" wrote in message
...
Hi

Please help!

I have a selection of data pulled down into a sheet using an ODBC
connection. Great!
I use this data to create different pivot tables in other worksheets (in
the
same workbook).

However when I apply grouping levels on pivot table it applies to the
other
pivot tables in a different work sheet. It is so ANNOYING!

Can anyone please tell me how I can prevent this?

Thanks