Hi All,

I am using Excel 2000. I wish to get ride of that "(ALL)" option in
Excel PivotTable PageFields by delete/hide it using VBA.

The surprising thing is: This "(ALL)" not belong to PivotItem of
PageFields or PivotFields. It seems can't be accessed UNLESS it is
displayed as

PageFields.VisibleItem(1) (by default)

When I try

PageFields.PivotItem("(ALL)").Visible = False

I always get the same error message:

"Object doesn't support this property or method"

Thanks in advance.

Charles