PowerPilot table on protected sheet - HowTo? RRS feed

  • Question

  • Hi,
    I'd like to create maximally protected sheet containink (Power)Pivot table. Users should only be able to use filters and/or pre-set horizontal/vertial slices.

    I've locked the sheet and used following well known example to lock tha table with only exception beig fefresh:

    With Worksheets("SheetName").PivotTables(1) .EnableWizard = False .EnableDrilldown = False .EnableFieldList = False .EnableFieldDialog = False .PivotCache.EnableRefresh = True 'Only Allowed refresh'
    For Each pf In .PivotFields With pf .DragToPage = False .DragToRow = False .DragToColumn = False .DragToData = False .DragToHide = False End With Next pf End With

    But all filtering attempts fail because pivot table data need refresh; also refresh is still greyed out.

    Thanks in advance for any advices/solutions.


    Thursday, April 25, 2013 10:23 AM


All replies