Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding data in Pivot Tables

    Is it possible to select multiple rows to be hidden in Pivot Tables, I have tried all (I believe) combinations of Shift, Alt, and Ctrl, but I cannot hide more than one row per click, which is awfully slow and tedious if there are lots of rows to be hidden.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Hiding data in Pivot Tables

    In Excel 97, right click on the Pivot table, and select Field settings. Then you can see a list box of the fields under the heading Hide Items. You just be highlight the fields you wish to hide, the only limitation being that there must be at least one visible item showing.

    Andrew C.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding data in Pivot Tables

    Thanks Andrew, what you described is my present method. However if you want to hide say the first 90 out of 100 fields, you have to click on the 90 one at a time. This is tedious. Clicking on row 1 and shift+clicking on row 90 doesn't select all 90 as happens in most other MS products. I was hoping someone knew a way to do this.

  4. #4
    New Lounger
    Join Date
    Feb 2001
    Location
    Chicago, Il USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding data in Pivot Tables

    Michael, I am afraid I do not have an answer to your problem as I found this thread while searching for the same answer myself. We need an "uncheck all" button but can't seem to find it, I guess.

    Can I assume you never found a solution to this problem?

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding data in Pivot Tables

    Hi Folks:
    Don't get excited cause I don't have an answer but would like you to remember me if youo find one. I also looked for a way to know which fields had been hidden, say by myself or a previous user, eithout opening the list box and scrolling up and down to look for shaded rows.
    sstollma@juno.com

  6. #6
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding data in Pivot Tables

    I think this may help

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Hiding data in Pivot Tables

    Stephen,

    I am attaching a file with some code in a userform which tries to do something like you want. It ahs lists for Visible and Hidden field items and the entries for both can be switched to either state. I have not tested it against a PT with a large number of items, but it might be of some help. It works on PivotTables in the active worksheet, and if there are more than one you can select the one to work with. It is bit rough and ready but if it is useful we can clean it up.

    Andrew
    Attached Files Attached Files

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding data in Pivot Tables

    Hi Andrew:
    I just downloaded the file and will attempt to use it. If it works, it will be a help. If I get an error I can't fix, I will get back to you.
    Regards,
    Stephen

Posting Permissions

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