View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
trainer07
 
Posts: n/a
Default How do you update a pivot chart when the data is changed?

When I change/edit the source data in my Pivot Table and then refresh the
pivot table, the new data is displayed. However, when I click on the drop
down arrown of one of my fields in the pivot table, the old data (along with
the new data) is still being displayed. How can I delete the old data from
the drop down box?