PIVOT Table hide filter.

[Nitesh Khot]

Hi is there any option to hide pivot table filter but not heading.

 

[GFC]

Under Pivot table Tools (pink menu in XLS 2010) in "option sub tab"
in the ribbon at the right you have severa show options
One is called Field headers (clicking on the button will dispay or hide)

 

[Nitesh Khot]

But I want that to remove filter only ....if i clicking on field headers pivot table headers got hide.

I want only to remove filter not heading.

Please help in this regards.

 

[ashish mehra]

Hi Nitesh Khot,

Try http://www.contextures.com/xlPivot12.html

Hope this will help you.

Regards,
AM

 

[Nitesh Khot]

Thanks this is working absolutely right as i want.

 

[ashish mehra]

Glad you got the desired output.

Regards,
AM

 

[Nitesh Khot]

Hi..,
pls use this code to remove filter from all pivot table in active workbook.

Sub removepivotfilter()

Dim pt As PivotTable
Dim pf As PivotField
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
        For Each pt In ws.PivotTables
            For Each pf In pt.PivotFields
            pf.EnableItemSelection = False
              Next pf
        Next pt
    Next ws
               
End Sub

 

[Hjoyce]

Hi Nitesh, could I pretty please get the macro to add the filters back in? Thanks the first macro worked a dream, but I have to go back and make some edits