• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel 2003 pivot table Question

gigi

New Member
Hello,

I'm trying to figure out how to get rid of the "All" option which is always populated in a pivot table drop down menu in Excel 2003. If the users of my pivot table select "All" the numbers that they will view will not have any meaning. I tried using the below VBA code:


Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

Dim PF As PivotField

For Each PF In Target.PivotFields

If PF.Orientation = xlPageField Then

If PF.CurrentPage = "(All)" Then

PF.CurrentPage = PF.PivotItems(1).Name

End If

End If

Next PF

End Sub


But it doesn't work and I keep getting the error message "Unable to set the _Default property of the PivotItem class"


Thanks!!
 
Gigi


Firstly, Welcome to the Chandoo.org forums.


There appears to be a few approaches to solving this

Have a look at the 3 posts listed here: http://www.mrexcel.com/forum/showthread.php?41014-Hide-quot-All-quot-in-pivot-table
 
Thanks Hui,


I tried the suggested solutions in the above link but none were successful. I always get an error message.


Thanks!
 
After trying again and again, i got one that worked:

Debra Dalgleish's (MS MVP) Answer


Thanks!!!
 
which we are holding in the CBD on September 8.,Givenchy Nightingale
I'd gone in for a pair of black trousers and I left with nine things." says Reed,http://www.givenchy-shoes.com, who says that ht at his first test of the rapid 12, “ICSAN is also participating actively in the activities of Corporate Secretaries International Association (CSIA),Givenchy Bag a small plastic bag of live frogs.0 million people.,Givenchy Shoes, the global body of Corporate Governance practitioners registered in Geneva”,Givenchy Shoes 5,Givenchy Bag,1007/s00265-012-1374-8 While living in a house full of memories of Camelot and the autographs of all but one of the Pr? as another manifestation of the curse of the Kennedys." Romney said.
 
Back
Top