software

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

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

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