Excel Question - Not rv related

Click inside your Pivot Table and in the menu ribbon under PivotTable Tools choose the Options tab and then select the Options drop down and choose Show Report Filter Pages.

Did that help?

Admin
RV.net

Admin wrote:
Click inside your Pivot Table and in the menu ribbon under PivotTable Tools choose the Options tab and then select the Options drop down and choose Show Report Filter Pages.

Did that help?

Admin
RV.net

I found a youtube video with those instructions but my options tab doesn't have a Show Report Filter Pages option, not even greyed out. I could do it easily on my older excel version but now that I am paying for the subscription model, it all looks different. Thanks for trying.

When in your pivot table, assuming you have created the table with at least one filter, if you put the cursor within the table, do you get a ribbon menu item above called PivotTable Analyze? If so, click on that, then on the left click the down arrow next to Options and you should have that available.

As Dave in TN mentioned, this is what I get when I open one of my Excel pivot tables in Office 2019 (MS 365) - sorry not Excel 2016. Once you click within the PivotTable:

I pay for Office 365 so I would like to think my Excel version would work the same, but when I click on my pivot table Anyalyze, then Pivot table, then Options, there is no line for Show Report Filter Pages. No line at all; I could see if it were greyed out that maybe I have some option set wrong. Thanks for trying. I have to move on to something else now. If I figure out the solution later, I will post again.