Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Page
Is there a way to remove "all" as an option from a page on a pivot table?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Page
You can remove all of a specific category by going to the pivot category
itself and selecting the down arrow on the main page. That will produce a drop down list and you can deselect the check boxes for whatever you don't want to view in the table. "PFLY" wrote: Is there a way to remove "all" as an option from a page on a pivot table? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Page
You can't remove the "All" option in the page field. With programming,
you could select another item if the user selects "All". For example, the following 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. Change the field name to match your pivot table '======================== Private Sub Worksheet_Change(ByVal Target As Range) Dim pt As PivotTable Dim pf As PivotField Dim i As Long Set pt = Me.PivotTables(1) Set pf = pt.PivotFields("Employee") With pf If .CurrentPage = "(All)" Then i = 1 For i = 1 To pf.PivotItems.Count + 1 On Error Resume Next .CurrentPage = .PivotItems(i).Name If Err.Number = 0 Then Exit For End If Next i MsgBox "The (All) option is not available" End If End With End Sub '============================ PFLY wrote: Is there a way to remove "all" as an option from a page on a pivot table? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page field - pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Page fields | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Pivot Table Page Fields | Excel Discussion (Misc queries) |