updating the data range for a pivot table

[dwojtowi]

Hello,
I am using pivot tables in a sheet to summarize data, and I added
few rows to the original table that the pivot tables are drawing from.
How can I update the data range that the tables pull from withou
having to redo all the pivot tables??

Thanks a lot!
Dav

 

[Andy Brown]

I am using pivot tables in a sheet to summarize data, and I added a

few rows to the original table that the pivot tables are drawing from.
How can I update the data range that the tables pull from without
having to redo all the pivot tables??

Use a dynamic named range as the "master" table data source ; see here

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

for how.

Rgds,
Andy

 

[George Nicholson]

Right click on the pivot table.
Select "Wizard".
Click "Back".
Modify the existing Data Source (if all you've done is add columns/rows,
Shift-Click the last used cell).
Click Finish

-or- use a dynamic range for your pivot table (as another response has
suggested)

HTH,
George Nicholson

Remove 'Junk' from return address.