View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dennisp dennisp is offline
external usenet poster
 
Posts: 5
Default How do I update the data in the pulldowns at the top of the pivot

I have a simple pivot table that shows hours per month by project for each
employee. I have deleted several of the employees from the source data
table, but the names continue to show up in the pulldown list at the top of
the pivot table. I have refreshed the numerous times but the only way I can
rid myself of the bad data is delete the pivot table and build it again.