excel filter not working on large file

This occurs when filtering using both the drop down filter as well as the custom method. Scroll further down and check the option…