Why is drop down not working in Excel?
Drop down list in Excel fails to work if your worksheet is corrupted. Sometimes the files also get corrupted but they can be fixed by using the repair option. To repair you will need to locate your file.
How do you fix filters not working in Excel?
What to do In the Compatibility Checker, click Find to locate the data that has been filtered, and then you can clear the filter to unhide the rows that are hidden. On the Home tab, in the Editing group, click Sort & Filter, and then click Clear to clear the filter.