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