Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Question Unanswered: Confused PivotItem.visible works with =false, but does not work with =true

    I'm Confused,... PivotItem(i)=false works, PivotItem(i)=true doesn't work

    'works -> pvtTable.PivotItems("productTEST").Visible = False
    'doesn't works -> pvtTable.PivotItems("productTEST").Visible = True

    Even when I let Excel Macro recorder do the work of selecting and then try to run it, it does not work.

  2. #2
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    You only need PivotItem(i)=false. This is so you can exclude selections from your pivot table, the same as selecting the drop down box on the field and unchecking the box. If you do not have the PivotItem(i)=false statement, then the Item is included and a 'true' statement is not needed.

    TD

  3. #3
    Join Date
    Nov 2004
    Posts
    2

    Thanks Buckeye,...

    I really wanted to deselect and select different products in the pivot table. It is created by someone else and is not consistent from day to day with what is in the pivot field, generally over 200 items in the table. I guess I could do one product group, get the results and then close and reopen the spreadsheet again for a different group of products to select. Any thoughts would be greatly appreciated.
    thanks again!

Posting Permissions

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