View Single Post
  #1   Report Post  
Nacho
 
Posts: n/a
Default 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