Limits of Auto Filter ('97 vs 2000)

ammdumas · Mar 27th, 2002, 11:13 AM

The Autofilter on a spreadsheet ('97) at work here seems to have a limit of about row 2800. Is this right or is there a bug? The problem seems to disappear in Excel 2000. Is there a limit or is there something wrong with the spreadhseet?

Yogi Anand · Mar 27th, 2002, 11:29 AM

Hi ammdumas:
I am using Excel 97, and I just checked use of AUTOFILTER with some 2900 records (although I used just a single column), it worked fine -- it did not tell me anything about a limit of 2800 records. How large is your table? Could it be a memory issue? .. Just Wondering!

ammdumas · Mar 27th, 2002, 11:38 AM

Table is some 5000 rows by 32 columns. For some reason, if you physically select the entire table by cell(i.e. dragging as oppose to selecting the row or column headings) it works. I thinking a memory thing too or maybe something within the table is keeping it from searching past a certain point.

Chris Davison · Mar 28th, 2002, 01:17 PM

I think it's 1000 unique values max.....

so maybe your 2800 rows contain 1800 items which are duplicates....

just tested with 1 to 1200 in cells A1 to A1200..... only 1 to 1000 shows up

Jack in the UK · Mar 28th, 2002, 04:22 PM

Yep Chris as i know 1st 1000 unique...

Mar 27th, 2002, 11:29 AM	#2
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi ammdumas: I am using Excel 97, and I just checked use of AUTOFILTER with some 2900 records (although I used just a single column), it worked fine -- it did not tell me anything about a limit of 2800 records. How large is your table? Could it be a memory issue? .. Just Wondering! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Mar 28th, 2002, 01:17 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	I think it's 1000 unique values max..... so maybe your 2800 rows contain 1800 items which are duplicates.... just tested with 1 to 1200 in cells A1 to A1200..... only 1 to 1000 shows up __________________ :: Pharma Z - Family drugstore ::

Mar 28th, 2002, 04:22 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Yep Chris as i know 1st 1000 unique... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 11:13 AM	#1
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	The Autofilter on a spreadsheet ('97) at work here seems to have a limit of about row 2800. Is this right or is there a bug? The problem seems to disappear in Excel 2000. Is there a limit or is there something wrong with the spreadhseet?

Mar 27th, 2002, 11:38 AM	#3
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	Table is some 5000 rows by 32 columns. For some reason, if you physically select the entire table by cell(i.e. dragging as oppose to selecting the row or column headings) it works. I thinking a memory thing too or maybe something within the table is keeping it from searching past a certain point.