Make a copy of the pivot table
Right-click a cell in the copy, and choose PivotTable Wizard
Click the Back button, and in the Range box, select the new source
Click Finish

To clear old items from the pivot table, you can use one of the
techniques shown he

http://www.contextures.com/xlPivot04.html

UPe wrote:
I have created a pivot table with custom formulas and formatting. I now need
to recreate the pivot table on a different data set with identical variable
names dimensions.

Is there a way to create a new pivot table on the new data without starting
from scratch and recreating the custom formulas and formatting?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html