Hi Debra,

I have used a dynamic range, but the pivot table doesn't auto refresh, is
there any way to make the pivot table update automatically as new data is
added?

"Debra Dalgleish" wrote:

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 he

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