Reuse of Pivot tables

Giganews Newsgroups
Subject: Reuse of Pivot tables
Posted by:  watkincm
Date: Tue, 13 Jun 2006

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