View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PIVIT TABLE
 
Posts: n/a
Default 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