Sort & filter buttons are (suddenly) not available in Excel table

I have an Excel Table (created by CTRL+T), where filter buttons are added by default. But suddenly they disappeared and the checkbox for switching them on/off is greyed out.

There are two other tables in same sheet and they work properly. I can't figure what causes this behavior.

Sceenshot: enter image description here

Copying sheet to another/new workbook doesn't help. How can I stop this from happening?


Solution 1:

I had the same issue. When I turned "header row" off and on again they reappeared. (Yes I am congnizant of the fact that it sounds like a fix to every other MS apps issue... but it actually worked for me.)

Solution 2:

Select all of the headers, go to Home>Sort & filter> and make sure the filter button is selected in this option. That should fix it for you