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

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

narkiparki wrote:
I have a pivot table for my wages file. when an employee leaves i would
like to remove them completely from the field as it can get quite full


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