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