Pivot Tables - cleaning up combo boxes history

[Guest]

I have a pivot table with customers orders updated every week. The thing is
that as I just update the information every week, the combo boxes of the
pivot table retain all the clients I ever showed (over 2000), even though
most of them are not used. Is there a way of cleaning up this combo list
other than creating a new pivot table?

Many Thanks,
from Argentina,
Nacho

 

[Debra Dalgleish]

There's information here on clearing old items in a pivot table:

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