Excel Filtering problem

  toogie 11:39 02 Dec 10
Locked

I have some large spreadsheets where the first column is in a date format. I have recently become aware that when I try to Filter on these colums I am only able to see dates to a certain point e.g. on one of my spreadsheets I have 4688 records but the Filter only allows me to select to record 2059. I have the same problem in other spreadsheets but the record numbers are different.I have been using Excel for many years and have not expoerienced this problem before. I have checked that the Date formats are correct and that there are no screens "frozen". Any help would be much appreciated.
Thanks

  VoG II 11:45 02 Dec 10

This explains the limit on the number of records that AutoFilter can handle click here

  toogie 12:06 02 Dec 10

Thanks VoG - Great, I now understand and will reformat my spreadsheets to overcome the Excel in-built restriction.

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now