adding rows to pivot table
 

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


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=376800

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

--
George Nicholson

Remove 'Junk' from return address.


"cwinters" wrote in
message ...

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


--
cwinters
------------------------------------------------------------------------
cwinters's Profile:
http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=376800

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

cwinters wrote:

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

--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=376800

--

Dave Peterson