I have a large database in Excel (40,000+ rows).
When using the drop down filter button, it appears that only the top 1000
selections appear in the selection list box. This caused me to make a number
of incorrect decisions before I realised the limitation existed.
a) Is there any way to remove this restriction or to increase it to say 2000
b) Surely when this limit is reached, a warning message should appear as the
autofilter function becomes misleading.

--
JohnG