"Jooles" wrote:
Can anyone tell me why auto filter in 1 spreadsheet with over 5,635 entries
shows all entries and why another spreadsheet with 1,026 entries only shows
some of the entries.

I know that the drop down limit is 1,000 but can't figure out why auto
filter shows all entries in 1 spreadsheet but not the other

One possibility is that there are probably "breaks" (empty rows) within the
table of data. Try this: Remove the autofilter, press CTRL+END to go to the
last used cell (bottom right), then re-select the entire table from that last
used cell/last row up, then re-apply the autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---