+ Reply to Thread
Results 1 to 4 of 4

What happened to Pivot Table "Show Pages"?

  1. #1
    Jim Molter
    Guest

    What happened to Pivot Table "Show Pages"?

    What happened to the functionality in Pivot Tables to write a new worksheet
    for each value in a Page Field?
    I'm sure that it was available in earlier versions of Excel, indeed there
    are references to "show pages" in other threads in this group, but I can't
    find it in Excel 2003.

    Did it go away?

    --
    Jim

  2. #2
    Debra Dalgleish
    Guest

    Re: What happened to Pivot Table "Show Pages"?

    On the Pivot Table toolbar, choose PivotTable > Show Pages

    Jim Molter wrote:
    > What happened to the functionality in Pivot Tables to write a new worksheet
    > for each value in a Page Field?
    > I'm sure that it was available in earlier versions of Excel, indeed there
    > are references to "show pages" in other threads in this group, but I can't
    > find it in Excel 2003.
    >
    > Did it go away?
    >



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


  3. #3
    Jim Molter
    Guest

    Re: What happened to Pivot Table "Show Pages"?

    Well, I'm not completely nuts! The default installation doesn't include that
    button on the Pivot Table toolbar.

    Thanks for your prompt and enormously helpful reply!
    --
    Jim


    "Debra Dalgleish" wrote:

    > On the Pivot Table toolbar, choose PivotTable > Show Pages
    >
    > Jim Molter wrote:
    > > What happened to the functionality in Pivot Tables to write a new worksheet
    > > for each value in a Page Field?
    > > I'm sure that it was available in earlier versions of Excel, indeed there
    > > are references to "show pages" in other threads in this group, but I can't
    > > find it in Excel 2003.
    > >
    > > Did it go away?
    > >

    >
    >
    > --
    > Debra Dalgleish
    > Excel FAQ, Tips & Book List
    > http://www.contextures.com/tiptech.html
    >
    >


  4. #4
    Debra Dalgleish
    Guest

    Re: What happened to Pivot Table "Show Pages"?

    You're welcome. I'm glad you found it!

    In Excel 2000, Show Pages was also included in the shortcut menu that
    appears when you right-click on the pivot table. In Excel 2002 and Excel
    2003, it's not there.

    Jim Molter wrote:
    > Well, I'm not completely nuts! The default installation doesn't include that
    > button on the Pivot Table toolbar.
    >
    > Thanks for your prompt and enormously helpful reply!



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1