Pivot Table

  • Thread starter Thread starter Ket
  • Start date Start date
K

Ket

Hello,

I am using excel 2000 on Windows 2000.

Is it possible to make changes to a pivot table on a protected
worksheet?
Even if I unlock the cells around my pivot table and then protect the
sheet, I am presented with a message saying I cannot edit a pivot
table on a protected worksheet.
Any ideas how I can get around this please?

TIA

Ket

London
 
i just know that its not possible, i have my whole workbook protected except
for pivot for the same reason! if u come 2 know pls let me nkow too1

Jim
 
Maybe you could move the pivot table to a separate, unprotected
worksheet. Then, to limit the changes that users can make to the layout,
you can run code similar to the following:

'===========================
Sub RestrictPivotTable()
Dim pf As PivotField
With ActiveSheet.PivotTables(1)
.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
End With
End Sub
'=========================
 
Back
Top