Pivot Table Auto Update Data Source?

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 here:

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

I did this by adding a VBA code of the Data source

ThisWorkbook.RefreshAll