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?

- 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" <cwinters.1q7pqc_1118073905.5668@excelforum-nospam.com> wrote in
message news:cwinters.1q7pqc_1118073905.5668@excelforum-nospam.com...
>
> 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