Pivot Tables - Row Selection

[Guest]

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]

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

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

 

[Guest]

Thanks

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

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