updating pivot table to include additional rows

Tried Refresh Table to update the pivot table. My experience with the
Refresh Table will update the values in the data that I've used to create the
pivot table with. My issues is adding additional rows to the data and having
these new rows added to the pivot table. for example, creating a pivot table
asks the range of cells to create the table with, A1-G343. If I add rows
A344-G454, these are not included in the data. I'd like all rows A1-G454
included in the pivot table without redefining the pivot table.

Is it possible to do this?

You could use a dynamic range as the pivot source -- there are
instructions here:

http://www.contextures.com/xlPivot01.html

Ellen wrote:
> Tried Refresh Table to update the pivot table. My experience with the
> Refresh Table will update the values in the data that I've used to create the
> pivot table with. My issues is adding additional rows to the data and having
> these new rows added to the pivot table. for example, creating a pivot table
> asks the range of cells to create the table with, A1-G343. If I add rows
> A344-G454, these are not included in the data. I'd like all rows A1-G454
> included in the pivot table without redefining the pivot table.
>
> Is it possible to do this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra - thank you. This looks like what we'd like to do.

"Debra Dalgleish" wrote:

> You could use a dynamic range as the pivot source -- there are
> instructions here:
>
> http://www.contextures.com/xlPivot01.html
>
> Ellen wrote:
> > Tried Refresh Table to update the pivot table. My experience with the
> > Refresh Table will update the values in the data that I've used to create the
> > pivot table with. My issues is adding additional rows to the data and having
> > these new rows added to the pivot table. for example, creating a pivot table
> > asks the range of cells to create the table with, A1-G343. If I add rows
> > A344-G454, these are not included in the data. I'd like all rows A1-G454
> > included in the pivot table without redefining the pivot table.
> >
> > Is it possible to do this?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

You're welcome! Thanks for letting me know.

Ellen wrote:
> Debra - thank you. This looks like what we'd like to do.
>
> "Debra Dalgleish" wrote:
>
>
>>You could use a dynamic range as the pivot source -- there are
>>instructions here:
>>
>> http://www.contextures.com/xlPivot01.html
>>
>>Ellen wrote:
>>
>>>Tried Refresh Table to update the pivot table. My experience with the
>>>Refresh Table will update the values in the data that I've used to create the
>>>pivot table with. My issues is adding additional rows to the data and having
>>>these new rows added to the pivot table. for example, creating a pivot table
>>>asks the range of cells to create the table with, A1-G343. If I add rows
>>>A344-G454, these are not included in the data. I'd like all rows A1-G454
>>>included in the pivot table without redefining the pivot table.
>>>
>>>Is it possible to do this?
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I'm no expert so please have someone verify. I insert a blank row at the top of the data and put the new data there, then just refresh the pivot chart and it picks up all the rows.