Pivot table field dropdown list reset

[Guest]

I would like to know if there is a way to reset a field dropdown list in a
pivot table. In some field sometimes I delete data from the source and some
items of the field will no longer be there. However, when I refresh the pivot
table the dropdown list will still show the old items even if they're not in
the source data anymore. I really need your help with this.

Thanks a lot in advance for your help,

Francisco Molina

 

[Frank Kabel]

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

 

[Guest]

Thanks a lot, this works perfectly.

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