Pivot Tables - Row Selection
 

I have external data comming in from a database, when i alter the data the
pivot table still shows row selections from the old data as well as the new,
is there any way to reset the list without removing and adding back in the
table. I cant find where in the spreadsheet it stores this information.

Steve

There are instructions here for clearing old items from the dropdown lists:

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


Steve wrote:
I have external data comming in from a database, when i alter the data the
pivot table still shows row selections from the old data as well as the new,
is there any way to reset the list without removing and adding back in the
table. I cant find where in the spreadsheet it stores this information.

Steve


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

Thanks

"Debra Dalgleish" wrote:

There are instructions here for clearing old items from the dropdown lists:

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


Steve wrote:
I have external data comming in from a database, when i alter the data the
pivot table still shows row selections from the old data as well as the new,
is there any way to reset the list without removing and adding back in the
table. I cant find where in the spreadsheet it stores this information.

Steve


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