Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cleaning up pivot tables | New Users to Excel | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |