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.
- Edited by Miroslav PráglMVP Thursday, April 25, 2013 10:25 AM