Excel 2002 Pivot Table Protection

[Guest]

I've been playing around with protecting my pivot table - so far, I can't get
it quite right. What I'm hoping to do is allow users to refresh the pivot
table and update any of the "page" dimensions, but NOT allow anyone to pivot
or manipulate the row and column dimensions.

Is this possible?

 

[Debra Dalgleish]

You could use programming to restrict the pivot table use. For example:

'=========================================
Sub RestrictPivotTableExceptPage()
Dim pt As PivotTable
Dim pf As PivotField
Set pt = ActiveSheet.PivotTables(1)
With pt
.EnableWizard = False
.EnableDrilldown = False
.EnableFieldList = False
.PivotCache.EnableRefresh = True
For Each pf In .PivotFields
pf.DragToPage = False
pf.DragToRow = False
pf.DragToColumn = False
pf.DragToData = False
pf.DragToHide = False
Next pf
For Each pf In pt.RowFields
pf.EnableItemSelection = False
Next
For Each pf In pt.ColumnFields
pf.EnableItemSelection = False
Next
End With
End Sub
'==============================