Excel 2016 filters do not work

PetraT - Aug 4, 2017 at 05:16 AM - Latest reply: ac3mark 9968 Posts Monday June 3, 2013Registration dateModeratorStatus July 19, 2018 Last seen
- Aug 4, 2017 at 04:54 PM
Hello,

My filter stopped working in 2016. It is completely inactive - doesn't show any other option only the one it froze on. In the menu the filter is inactive - grey, so there is no way to disable it and make it work again. I got rid of hidden columns with no values, I am not sure what else to do. I would be very happy for an advice!

Thank you! Petra


See more 

Your reply

1 reply

ac3mark 9968 Posts Monday June 3, 2013Registration dateModeratorStatus July 19, 2018 Last seen - Aug 4, 2017 at 04:54 PM
0
Thank you
SO, in the menu of DATA, the filter is grayed out there too? Highlight the first row of about 4 cells, and goto DATA, FILTER. What happens?
Respond to ac3mark