Hi all
Is there a limit to the number of values that show in the drop down list when using the auto filter feature in Excel?
We have a sales spreadsheet that goes back to 1997, and the dates on the filter list on the date column only go to Sept 03, all the ones after that do not show in the list, but can still be seen when you do a custom filter.