After I've deleted data that I use in my pivot table/chart, how do I get rid
of the items that are still appearing in the drop down menus for each field?
For example: I deleted a line because that person no longer work in this
company, but their ID still appears in the USER ID field even though there
are no more occurences of that item.

Hi,

Does Debra's explanation help, I'm sure it will.
http://www.contextures.com/xlPivot04.html

Cheers
Andy

Stephen wrote:
> After I've deleted data that I use in my pivot table/chart, how do I get rid
> of the items that are still appearing in the drop down menus for each field?
> For example: I deleted a line because that person no longer work in this
> company, but their ID still appears in the USER ID field even though there
> are no more occurences of that item.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info