Data validation drop down not returning all options

Drop down looking at 120,000 rows of a separate worksheet. Auto complete works for many but not all options. The filter option on the worksheet containing the list also falls to return these "problem cells". I've tried using get and transform but still can't get it to work.