Reuse of Pivot tables

W

watkincm

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?
 
D

Debra Dalgleish

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.
 
Top