Duplicating Pivot Tables
 

I have worked with Pivot Tables for several years; but am only recently using
them in Excel 2007.

In previous versions, once I had created a Pivot Table, I could select it,
copy it, then paste it to another location and modify it. This only works
with some success in Excel 2007.

It appears that all of the Pivot Tables I have created from the initial
Pivot Table remain linked together, and changing aspects of one of them will
cause them all to change.

For example, I am using the "grouping" feature on the data in the Row
Labels. It contains percentages from -100% to +100%. I am grouping in 10%
bands (e.g. from -1 to 1 by .1). I then copy the table, paste it in another
location (same worksheet or different, but still the same workbook). I need
to group everything between -10% and +10% by 1% bands (e.g. from -0.1 to 0.1
by 0.01).

However, doing this latter grouping also changes the grouping on the
original pivot table.

Similarly, if I clear the data, or change the data range on any of the Pivot
Tables, they all change.

How can I "unlink" copies of Pivot Tables so I can modify them each
independently?

Thanks

Duplicating Pivot Tables
 

Hi

Create a second Table with the same range as your first source range, using
Insert tabTable.
Note the name given to the table, e.g. Table 2, or give it a new name
yourself. Table ToolsDesignTable Name.
Place cursor in any cell of second Pivot TablePivot Table
ToolsOptionsDataChange Sourceset it to your new table.

Now, any changes made will be independent of each other, even though it is
the same set of data that is being viewed.

--
Regards
Roger Govier

"FlyGuyTX" wrote in message
...
I have worked with Pivot Tables for several years; but am only recently
using
them in Excel 2007.

In previous versions, once I had created a Pivot Table, I could select it,
copy it, then paste it to another location and modify it. This only works
with some success in Excel 2007.

It appears that all of the Pivot Tables I have created from the initial
Pivot Table remain linked together, and changing aspects of one of them
will
cause them all to change.

For example, I am using the "grouping" feature on the data in the Row
Labels. It contains percentages from -100% to +100%. I am grouping in
10%
bands (e.g. from -1 to 1 by .1). I then copy the table, paste it in
another
location (same worksheet or different, but still the same workbook). I
need
to group everything between -10% and +10% by 1% bands (e.g. from -0.1 to
0.1
by 0.01).

However, doing this latter grouping also changes the grouping on the
original pivot table.

Similarly, if I clear the data, or change the data range on any of the
Pivot
Tables, they all change.

How can I "unlink" copies of Pivot Tables so I can modify them each
independently?

Thanks