Pivot Tables
 

I use the wonderful pivot a lot. I use SQL to get dvolitile data and then
refreash the pivot. Is there a way to "scrub" the pivot memory without
starting all over, i.e., data in the pivot select is persistant from the
prior refreshed even when not in the current data set. Its correctly not in
the final pivot, but continues to appear in new select list? thx in advance

Pivot Tables
 

There are instructions here for clearing old items from a pivot table:

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

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


"cww" wrote:

I use the wonderful pivot a lot. I use SQL to get dvolitile data and then
refreash the pivot. Is there a way to "scrub" the pivot memory without
starting all over, i.e., data in the pivot select is persistant from the
prior refreshed even when not in the current data set. Its correctly not in
the final pivot, but continues to appear in new select list? thx in advance

Pivot Tables
 

thx!! most helpful

"Debra Dalgleish" wrote:

There are instructions here for clearing old items from a pivot table:

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

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


"cww" wrote:

I use the wonderful pivot a lot. I use SQL to get dvolitile data and then
refreash the pivot. Is there a way to "scrub" the pivot memory without
starting all over, i.e., data in the pivot select is persistant from the
prior refreshed even when not in the current data set. Its correctly not in
the final pivot, but continues to appear in new select list? thx in advance