I'm looking to remove the (All) section from under the page area in a pivot
table. I cant find code nor a way to remove this option.

Thanks,
Tim

You can't. Sorry.
--
Gary Brown

Please rate this posting if it is helpful to you.


"Tim" wrote:

I'm looking to remove the (All) section from under the page area in a pivot
table. I cant find code nor a way to remove this option.

Thanks,
Tim

This workaround was posted by Debra Dalgleish:

You can't suppress the "All" option in the page field. With programming,
you could select another item if the user selects "All".

For example:
'========================
Private Sub Worksheet_Change(ByVal Target As Range)
Dim pt As PivotTable
Dim pf As PivotField
Set pt = Me.PivotTables(1)
Set pf = pt.PivotFields("Rep")

With pf
If .CurrentPage = "(All)" Then
.CurrentPage = .PivotItems(1).Name
End If
End With
End Sub
'============================

This code is stored on the worksheet's code module --
Right-click the sheet tab, and choose View Code
Paste the code where the cursor is flashing.

Tim wrote:

I'm looking to remove the (All) section from under the page area in a pivot
table. I cant find code nor a way to remove this option.

Thanks,
Tim

--

Dave Peterson

Is this because the All section is used to contain the data and it just
performs a 'filter' on that data? I used the work around, just thought it
would be better to remove the item if it doesn't provide accurate information.

Thanks for all the help, I appreciate it!
Tim

"Tim" wrote:

I'm looking to remove the (All) section from under the page area in a pivot
table. I cant find code nor a way to remove this option.

Thanks,
Tim

Pivot Tables are OLAP Cubes. The Cubes pre aggregate the data so that when
you want to retrieve members it is extremely quick. The all feature just grab
the entire dimension of the cube. So it is not really a filter. Think of the
data items as having co-ordinates in the cube. All grabs the aggregate of all
of the members of the dimension in question. Since the numbers are
pre-aggregated there is really no way to omit the all. It exists in the cube.
Not that this explanation help you but it should give you some insight into
why it does what it does.

Jim Thomlinson


"Tim" wrote:

Is this because the All section is used to contain the data and it just
performs a 'filter' on that data? I used the work around, just thought it
would be better to remove the item if it doesn't provide accurate information.

Thanks for all the help, I appreciate it!
Tim

"Tim" wrote:

I'm looking to remove the (All) section from under the page area in a pivot
table. I cant find code nor a way to remove this option.

Thanks,
Tim