One thought is to simply set the pivot's source range (In step 2 of the PT
wizard) to cover the max expected extent of source data at the onset, then
configure the base PT format. Then just refresh the PT to recalc for any new
data added. The PT format should generally remain intact. Any help? hit YES
below.
--
Max
Singapore
---
"Jazz" wrote:
I used Sheet1 as the data source to create a pivot table in a new worksheet
which I named Sheet PT.

Is it possible to design the workbook so that I can delete the data in
Sheet1 and then paste new data with more or less rows in Sheet1 and have the
pivot table in Sheet PT update to reflect the new data that has been pasted
into Sheet1 but the formating of the pivot table stays the same?