Hi Mike

basically, when you click an AutoFilter arrow, a list is displayed of the
items in the column, in alphabetical or numeric order, up to a total of
1,000 items ...

so could it be that you didn't realise the list was in alpha order and your
items are further up / down the list than you expect. Otherwise, do you
have any completely blank rows in your data area ... if you do excel is
probably only using the data up to the blank line when generating the list.

let us know how you go ...

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
I have a sheet with several hundred lines. When I activate Autofilter, I am
missing some entries in the value list. I can clearly see them in the
sheet,
but not in value list. Is this a bug, and is there perhaps a fix? I am
using
Excel 2000 SP3.

mike