Excel Question - Not rv related

[2chiefsRus]

Not rv related but I am sure someone on here will know the answer. I have a Pivot table in excel 2016. I want to create a tab for each of about 50 options I have in my pivot table. I used to click on Show Report Filter Pages but I can't seem to find that in the new version. Can you help me?

[2chiefsRus]

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.

[1492]

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:

[Dave_in_TN]

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.

[2chiefsRus]

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.

[Admin]

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