how to remove old selection values in the pivot table
 

I have a field accept_reject_ind and it had values 'A', 'R', 'K' and you can
select any one of them in the pivot table to see your results. But now, I do
not have data with values 'K' but in the selection it still shows 'K' - how
do I remove it since it is no longer prsent in the data. Thanks for your
help

how to remove old selection values in the pivot table
 

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

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



PIVIT TABLE wrote:
I have a field accept_reject_ind and it had values 'A', 'R', 'K' and you can
select any one of them in the pivot table to see your results. But now, I do
not have data with values 'K' but in the selection it still shows 'K' - how
do I remove it since it is no longer prsent in the data. Thanks for your
help