Good Sam Club Open Roads Forum: Excel Question - Not rv related
Open Roads Forum Already a member? Login here.   If not, Register Today!  |  Help

Newest  |  Active  |  Popular  |  RVing FAQ Forum Rules  |  Forum Posting Help and Support  |  Contact  

Search:   Advanced Search

Search only in Technology Corner

Open Roads Forum  >  Technology Corner

 > Excel Question - Not rv related

Reply to Topic  |  Subscribe  |  Print Topic  |  Post New Topic  | 
2chiefsRus

USA Somewhere

Senior Member

Joined: 09/08/2004

View Profile





Offline
Posted: 02/20/21 06:46am Link  |  Quote  |  Print  |  Notify Moderator

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?


Dave & Kathy
2007 Monaco Knight 40PDQ towing 2018 Ford F-150 & 2017 Harley Trike
Fulltime 2007 to 2016, now halftimers
Before you give someone a piece of your mind, make sure you can get by with what will be left.
Our Blog
National Parks Visited

Admin

Channel Islands Harbor, Ca.

Administrator

Joined: 06/20/2000

View Profile



Posted: 02/20/21 09:38am Link  |  Quote  |  Print  |  Notify Moderator

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

2chiefsRus

USA Somewhere

Senior Member

Joined: 09/08/2004

View Profile





Offline
Posted: 02/20/21 09:56am Link  |  Quote  |  Print  |  Notify Moderator

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.

Dave in TN

Middle Tennessee

Senior Member

Joined: 11/28/2006

View Profile



Good Sam RV Club Member

Offline
Posted: 02/20/21 02:06pm Link  |  Quote  |  Print  |  Notify Moderator

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.

1492

Arlington, VA

Moderator

Joined: 04/08/2005

View Profile



Posted: 02/20/21 02:39pm Link  |  Quote  |  Print  |  Notify Moderator

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:


    [image]


2chiefsRus

USA Somewhere

Senior Member

Joined: 09/08/2004

View Profile





Offline
Posted: 02/21/21 05:34am Link  |  Quote  |  Print  |  Notify Moderator

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.

Reply to Topic  |  Subscribe  |  Print Topic  |  Post New Topic  | 

Open Roads Forum  >  Technology Corner

 > Excel Question - Not rv related
Search:   Advanced Search

Search only in Technology Corner


New posts No new posts
Closed, new posts Closed, no new posts
Moved, new posts Moved, no new posts

Adjust text size:




© 2021 CWI, Inc. © 2021 Good Sam Enterprises, LLC. All Rights Reserved.