software

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 quot;getquot; 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.

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

www.contextures.com/xlPivot01.html

Toni @ Fidelity wrote:
gt; I've created some pivot tables that rely on the data source, but the range of
gt; data in my data source changes frequently (not just the data in the range,
gt; but the range is constantly growing). How can I set the pivot table to
gt; automatically quot;getquot; all the data when it refreshes - not just changes to data
gt; in the range I previously defined? Is this something that can be done, or a
gt; limitation in Excel.
gt;
gt; By the way, I'm using Excel 2002.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThank you so much! This was very helpful. I'll be sure to bookmark your
site, it's most helpful.

Toni

quot;Debra Dalgleishquot; wrote:

gt; You can base the pivot table on a dynamic range, as described he
gt;
gt; www.contextures.com/xlPivot01.html
gt;
gt; Toni @ Fidelity wrote:
gt; gt; I've created some pivot tables that rely on the data source, but the range of
gt; gt; data in my data source changes frequently (not just the data in the range,
gt; gt; but the range is constantly growing). How can I set the pivot table to
gt; gt; automatically quot;getquot; all the data when it refreshes - not just changes to data
gt; gt; in the range I previously defined? Is this something that can be done, or a
gt; gt; limitation in Excel.
gt; gt;
gt; gt; By the way, I'm using Excel 2002.
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

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

Toni @ Fidelity wrote:
gt; Thank you so much! This was very helpful. I'll be sure to bookmark your
gt; site, it's most helpful.
gt;
gt; Toni
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt;
gt;gt;You can base the pivot table on a dynamic range, as described he
gt;gt;
gt;gt; www.contextures.com/xlPivot01.html
gt;gt;
gt;gt;Toni @ Fidelity wrote:
gt;gt;
gt;gt;gt;I've created some pivot tables that rely on the data source, but the range of
gt;gt;gt;data in my data source changes frequently (not just the data in the range,
gt;gt;gt;but the range is constantly growing). How can I set the pivot table to
gt;gt;gt;automatically quot;getquot; all the data when it refreshes - not just changes to data
gt;gt;gt;in the range I previously defined? Is this something that can be done, or a
gt;gt;gt;limitation in Excel.
gt;gt;gt;
gt;gt;gt;By the way, I'm using Excel 2002.

--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html