I want to hide the filter from the pivot table RRS feed

  • Question

  • I am connecting sass  database using Excel, from the pivot table i can able to see the cube result.

    ex: we have many juris .in that always i want to see the particular juris data alone.

    we have filter option but if we use this, customer possible to change the filter so i want to hide the filter from pivot table,its possbile ?,please suggest me 



    Tuesday, April 5, 2016 2:33 PM


  • Hi Pandiyan,

    If got you right you need to have one of PivotFields filtered and at the same time to prevent users from filtering this PivotField.

    Answering a question in another thread here I made a sample:


    To disable filtering "Pets" PivotField you can use something like the following:

    Sub DisableSelection()
        Dim pt As PivotTable
        Dim pf As PivotField
        Set pt = Sheet2.PivotTables("PetFilter")
        Set pf = pt.PivotFields("Pets")
        pf.EnableItemSelection = False
    End Sub

    Is that what you asked for?

    Sergiy Vakshul

    • Proposed as answer by Sergiy_Vakshul Tuesday, April 5, 2016 6:54 PM
    • Marked as answer by David_JunFeng Tuesday, April 12, 2016 9:24 AM
    Tuesday, April 5, 2016 6:54 PM

All replies