The "Show Report Filter Pages" is grayed out in Excel Pivot Table Analyze . How do I fix it?

Question

while i was working on my pivot table i found out that the show report fliter is greyed and i cannot get it to work any help would be appreciated

detlef_lewin · Answer

Joe_Amr&nbsp;&nbsp;https://techcommunity.microsoft.com/t5/excel/show-report-filter-pages/m-p/59095&nbsp;

joe_amr · Answer

i have tried all of that but still the same

sergeibaklan · Answer

Joe_Amr&nbsp;
Quite strange. If you DO NOT use data model standard behaviour is like

and PivoTable Fields pane looks like

If you use data mode, table name(s) are shown in above pane

How the pane looks in your case?

Forum Discussion