how do i refresh a pivot table drop down list in excel 2003?
 

when i remove data from my source tab, the entries still show in the drop
down list for the field in my pivot table. i am trying to figure out how to
remove them. i tried removing the field from the pivot table, refreshing the
pivot table, and then placing the field back in. that only works sometimes.