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

Auto Recover saves unsaved Excel files when the system shuts down. If Excel Excel Auto Recover is not working, take these steps to fix the issue.