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