Hi,
On my Workbook Open code I first clear the combo values then loop through all the pivot items in a pivot field to generate the new list (this is after pivot has refreshed, so items can vary each time).
However, some old values are still showing up which no longer exist in the pivot. The pivot table is linked to an Access query.
Can anyone help me to remove the old values?
Thanks
Baker
On my Workbook Open code I first clear the combo values then loop through all the pivot items in a pivot field to generate the new list (this is after pivot has refreshed, so items can vary each time).
However, some old values are still showing up which no longer exist in the pivot. The pivot table is linked to an Access query.
Can anyone help me to remove the old values?
Thanks
Baker