PDA

View Full Version : 1000 row filter


northernstar
02-24-2009, 11:31 PM
morning

is it possible to filter a spreadsheet in excel 2003 which has more than 1000 rows, if so how

thanks
Bob Phillips
02-25-2009, 01:37 AM
1000 unique items seems to be the absolute limit for autofilter, I don't think you can change that. Doesn't even seem to be changed in 2007.
northernstar
02-25-2009, 04:10 AM
yes it does seem to change in 2007, had over 3000?
Bob Phillips
02-25-2009, 05:29 AM
That is odd, I only got 999. Have you got SP1?
northernstar
02-25-2009, 05:32 AM
not sure would have to check on that

couldnt you write code to find a value and hide all other rows?
chungtinhlak
02-25-2009, 07:22 AM
It does seem to change
Reference (http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx)

Number of items shown in the Auto-Filter dropdown
Old Limit: 1,000
New Limit: 10,000