Pivot Table group levels
 

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

Pivot Table group levels
 

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

Pivot Table group levels
 

Hi Roger

Thank you for the reply but I dont see the setting that you mention.

I am using Excel 2007 and when I am on the data source I click insert pivot
table
I am then presented with the box that ask me to select a table or range
Then where I would like the pivot table to be placed... into an new
worksheet.

So if you could divulge a little more I would be most grateful.

Thanks

"Roger Govier" wrote:

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

Pivot Table group levels
 

Hi

OK, a little different with 2007.
First create a Table, by clicking anywhere in your Source and choose Insert
tabTable (NOT Pivot Table)
It will probably be called Table 1, but you can rename it to whatever you
want.
Click on the Table createdSelect Design tabSummarize with Pivot Table
Make your selections to the various areas etc.

Click on the table againDesign tabSummarise with Pivot Table
Set it up as you wish.

Each will have it's own cache, even though it is based upon the same source
table and any Grouping etc. will be independent.

I suspect you created your Multiple PT's by selecting your SourceInsert
tabPivot Table and repeated this many times.
This would use the same pivot cache for all tables.

--
Regards
Roger Govier

"Bunji" wrote in message
...
Hi Roger

Thank you for the reply but I dont see the setting that you mention.

I am using Excel 2007 and when I am on the data source I click insert
pivot
table
I am then presented with the box that ask me to select a table or range
Then where I would like the pivot table to be placed... into an new
worksheet.

So if you could divulge a little more I would be most grateful.

Thanks

"Roger Govier" wrote:

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