If you manually grouped the items, ungroup them.
If there are multiple pivot tables that use the same pivot cache, remove
the field from all the pivot tables.
Then refresh the pivot table, and add the field.

shadestreet wrote:
Debra, I have tried to manually clear the old items, but it doesn't
work. They still appear in my lists and I have checked the source data
to confirm they are removed completely.

I had to resort to using the macro you have on your site, which did the
trick for me (thankfully). Thanks, but why didnt the manual method
work?




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