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
|