create copy of pivot table - don't want to lose calculated fields

[Emeritus-1148]

Hi,
I have a pivot table with a number of calculated fields. I want to create another table on a different tab that will still have access to the calculated fields. I need ready access to several perspectives without having to rearrange the same table constantly.

In the "old" excel world, whenever I created a new pivot table the wizard would ask if I wanted to use the same source data as an existing table to keep the file smaller. I would say yes, and then I had another table with all the fields. No need to recreate the formulas.

Now, in 2007, when I create another table, the wizard does not ask the question - it just creates a new table. The new table does not have the calculated fields in it.

How do you get a "new" table on another tab, or even on the same tab for that matter, with access to all the calculated fields?

Thanks much.

 

[Emeritus-1148]

of course, i could always just do a copy paste of the entire worksheet to a new tab. that worked fine......