Autofilter - are number of rows limited?

[NickMinUK]

I have a spreadsheet some 20 columns wide by 6000 rows. Autofilter ha
been applied to all columns on the header row and has been workin
without any problem. Have recently made some modifications and remove
autofilter. After modifications, reapplied autofilter, but now it wil
only filter down to row 3541 (as opposed to row 6000 before). Can'
figure out why. Anyone any ideas

 

[Frank Kabel]

Hi
see: http://www.contextures.com/xlautofilter02.html#Limits

 

[NickMinUK]

Thanks for link Frank, but unfortunatly doesn't deal with this problem.
The issue is with the number of rows filtered, not the number of items
displayed in the drop-down. Nick

 

[Frank Kabel]

Hi
sorry. Have you checked that there're no blank rows in between?
Also try selecting your entiere data range and then apply autofilter

 

[NickMinUK]

Thanks Frank.
Selecting whole range works. Didn't need to b4, but now I know. Thank
again.
Nic