Pivot Tables - adding source data

[Jami]

Do I have to create a brand new pivot table every time I
add source data? I just want to add rows of data to the
source data and have the pivot table refresh and pick up
those extra rows in addition to the existing rows.

 

[Andy Brown]

Do I have to create a brand new pivot table every time I

add source data? I just want to add rows of data to the
source data and have the pivot table refresh and pick up
those extra rows in addition to the existing rows.

Create a dynamic named range for the source data - instructions here:

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

Rgds,
Andy