Combo Box - weird "Ghost" data

[Jabba69]

Hi
I have a weird combo box problem.
The combo box has a ListFillRange that is a Named Range which is dynamic and depends on slicer selection.

When no slicer filters are selected the combo dropdown seems fine.
However if I make a slicer filter then the combo dropdown will first contain the correct the correct X names, but instead of that being all (or even then showing the rest as blanks - not ideal, but would be ok), the list then repeats the names above!

But even weirder, the 'duplicate' entries are not in any particular order. If I then scroll back up to the top to the 'correct' list, when I scroll back down, the 'duplicate' data is in a different order (including random blanks).
If I try to select any of these 'ghost duplicates', nothing happens.

I've manually checked the Named Range, and this works as expected, as in when slicers are selected, the named range only selects the 'new' list. I've also tested using a standard Validation dropdown list, and also works correct.

Has anyone encountered this before??
Any help would be most appreciated.

[Jabba69]

Also, just checked and if I save whilst its doing this 'ghost duplicate' thing, then close and re-open, that the combo box then appears without them and works ok.

However if I then take the slicer selection off, the list does not go back to the original size and is restricted to the list that was there with the slicer!

[Jabba69]

Sorted!

I just had to add a command to 're-look' at the list once I'd made a slicer selection.

I added:

Please Login or Register  to view this content.

to an existing PivotTableUpdate Event code I had doing some other stuff.