Excel Autofilter Capacity

Giganews Newsgroups
Subject: Excel Autofilter Capacity
Posted by:  Mike Christie (mike.christ…@boalloy.org)
Date: Mon, 15 Jan 2007

We appear to have hit a barrier on the number of records autofilter will
return.

From a spreadsheet of over 5000 rows, only about 999 can be returned using
autofilter.

Is this a real capacity limit others have encountered or just us?

Is there a solution within Excel?

Mike Christie

Replies