Pivot Tables - cleaning up combo boxes history
 

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

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

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


Nacho wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html