If Excel filter is not working after certain row, for merged cells, on large files or on protected sheet, then see this post.