Hello,

I have a spreadsheet that contains a pivot table sheet1 and the data
source is sheet2.
I update the data source by adding new rows of data.
I then go to the pivot table and re-run the wizard to take into
account the new rows of data.
Is there an automated way that the pivot table will update with the
new rows of data added in sheet2?

TIA for any assistance offered.

Ket
London

You can use a dynamic range as the pivot table source, and it will
automatically expand as rows or columns are added. There are
instructions he

http://www.contextures.com/xlPivot01.html#Dynamic

Ket wrote:
I have a spreadsheet that contains a pivot table sheet1 and the data
source is sheet2.
I update the data source by adding new rows of data.
I then go to the pivot table and re-run the wizard to take into
account the new rows of data.
Is there an automated way that the pivot table will update with the
new rows of data added in sheet2?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html