+ Reply to Thread
Results 1 to 2 of 2

Unable to set visible property of the pivotitem class

  1. #1
    Forum Contributor
    Join Date
    06-24-2004
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    122

    Unable to set visible property of the pivotitem class

    Hello friends, hope all is well!

    I keep getting the error "Unable to set visible property of the pivotitem class"

    I have been trying, but don't know what editing needs to be done to see the code go thru.

    I am wondering, what is needed?

    Thanks a lot! in advance

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Unable to set visible property of the pivotitem class

    If it errors on this line...
    Please Login or Register  to view this content.
    ... it could mean that all pivot items have been hidden which is not allowed. At least one must remain visible.

    I don't know enough about your application to give you a definitive solution. If you know there will always be at least one match, then make all items visible before hiding the ones that don't match.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Error: Unable to set the visible property of the PivotItem Class
    By drewmey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-14-2015, 06:13 PM
  2. Unable to set visible property of the pivotitem class - error - how do I fix it
    By cmwilbur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2015, 04:23 PM
  3. Replies: 0
    Last Post: 06-14-2013, 12:33 PM
  4. unable to set the visible property of the pivotitem class
    By goldfrapp01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2013, 12:27 PM
  5. Unable to set the visible property of the PivotItem class
    By RagonichaFulva in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-29-2012, 02:51 AM
  6. Error 1004 unable to set the visible property of the pivotitem class
    By 4am in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-23-2012, 10:46 AM
  7. Error:Unable to set the visible property of the PivotItem class.
    By Holger Pietsch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2005, 01:05 PM

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