adding rows to pivot table

[cwinters]

I have a pivot table that refers to a 7000 row "rawdata" workboo
(A1:E7000) I just appended another 7000 rows of new data to tha
workbook (so now it is A1:E14000). However, my pivot table does no
seem to be including the new rows. How do I update the pivot table t
expand itself to include those new 7000 rows

 

[George Nicholson]

- right click the pivot table
- select Pivot table wizard
- select "Back"
- change (expand) the data source range to include your new data
- click "finish"

 

[Dave Peterson]

I'd use a dynamic range name that could expand and contract based on the number
of used cells in one of the data columns. (do you have a column that's always
filled???)

Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlNames01.html#Dynamic