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:
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:
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...
Bookmarks