Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out of ideas.

Thanks if you are able to assist

Martin