How do I set the pivot table to auto-update the data range?
 

I've created some pivot tables that rely on the data source, but the range of
data in my data source changes frequently (not just the data in the range,
but the range is constantly growing). How can I set the pivot table to
automatically "get" all the data when it refreshes - not just changes to data
in the range I previously defined? Is this something that can be done, or a
limitation in Excel.

By the way, I'm using Excel 2002.

How do I set the pivot table to auto-update the data range?
 

You can base the pivot table on a dynamic range, as described he

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

Toni @ Fidelity wrote:
I've created some pivot tables that rely on the data source, but the range of
data in my data source changes frequently (not just the data in the range,
but the range is constantly growing). How can I set the pivot table to
automatically "get" all the data when it refreshes - not just changes to data
in the range I previously defined? Is this something that can be done, or a
limitation in Excel.

By the way, I'm using Excel 2002.


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

How do I set the pivot table to auto-update the data range?
 

Thank you so much! This was very helpful. I'll be sure to bookmark your
site, it's most helpful.

Toni

"Debra Dalgleish" wrote:

You can base the pivot table on a dynamic range, as described he

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

Toni @ Fidelity wrote:
I've created some pivot tables that rely on the data source, but the range of
data in my data source changes frequently (not just the data in the range,
but the range is constantly growing). How can I set the pivot table to
automatically "get" all the data when it refreshes - not just changes to data
in the range I previously defined? Is this something that can be done, or a
limitation in Excel.

By the way, I'm using Excel 2002.


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

How do I set the pivot table to auto-update the data range?
 

You're welcome! Thanks for letting me know that it helped.

Toni @ Fidelity wrote:
Thank you so much! This was very helpful. I'll be sure to bookmark your
site, it's most helpful.

Toni

"Debra Dalgleish" wrote:


You can base the pivot table on a dynamic range, as described he

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

Toni @ Fidelity wrote:

I've created some pivot tables that rely on the data source, but the range of
data in my data source changes frequently (not just the data in the range,
but the range is constantly growing). How can I set the pivot table to
automatically "get" all the data when it refreshes - not just changes to data
in the range I previously defined? Is this something that can be done, or a
limitation in Excel.

By the way, I'm using Excel 2002.

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