Excel Filtering problem

  toogie 11:39 02 Dec 2010

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.

  VoG II 11:45 02 Dec 2010

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

  toogie 12:06 02 Dec 2010

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.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Lightwell software lets you create mobile apps without using code

Best value Mac: Which is the best £1249 Mac to buy

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?