Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2002 Pivot Table Protection
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? |
#2
|
|||
|
|||
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 '============================== Kirk P. wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Excel XP Pivot Table | Excel Discussion (Misc queries) | |||
How do I display a data table in an Excel 2002 chart? | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions |