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.

How do I update the data in the pulldowns at the top of the pivot
 

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

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


DennisP wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html