Reuse of Pivot tables
 

Is there a way to reuse a pivot?
I get an updated spreadsheet every week and currently rebuild the pivot
tables each time to produce regular reports. Is there a better way to do
this - carry an existing pivot across to the new worksheet somehow?
--
Mike Watkins

Reuse of Pivot tables
 

If the field names are the same, you could copy the pivot table into the
new workbook. Then, right-click on a cell in the pivot table, and choose
PivotTable Wizard
Click the Back button, and select the data range in the new workbook.

watkincm wrote:
Is there a way to reuse a pivot?
I get an updated spreadsheet every week and currently rebuild the pivot
tables each time to produce regular reports. Is there a better way to do
this - carry an existing pivot across to the new worksheet somehow?


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