+ Reply to Thread
Results 1 to 1 of 1

Uncheck "Select Multiple Items" in a Pivot Table Using Code (Excel 2007)

  1. #1
    Registered User
    Join Date
    03-31-2005
    Posts
    11

    Uncheck "Select Multiple Items" in a Pivot Table Using Code (Excel 2007)

    Hello! First, thanks for any help anyone can send my way - it will be appreciated!
    I haev 700+ pivot table files built in Excel 2003. My company recently upgraded to 2007. I've developed an extensive macro tool to "upconvert" all my files to Excel 2007. However, there's one piece yet that I just can't figure out!
    In the PageFields of my pivot table, it defaults to allowing the user to "Select Multiple Items." I need to have this option unchecked - without having to do it by hand on the 700+ files.
    I've found this piece of code:
    Please Login or Register  to view this content.
    However, it seems to have no effect. I think my problem might be that i'm not using cube/olap/etc type data - just regular excel data. From what I've been able to find, the enablemultiplepgeitems property only works with those types of source data. What am I missing??
    Thanks!!

    Well, I figured it out:
    Please Login or Register  to view this content.
    In 2003, we had hidden "blank." In 2007, blank was visible, but uncheck. So, I wrote the code to check blank, then disable the Multiple Items. Worked like a charm...
    Attached Images Attached Images
    Last edited by delecto; 04-02-2009 at 06:52 PM. Reason: Solved

+ 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