Block Cell

J

juanpablo

How can I block the content of a cell, so no one can change it, but keep the
functionality of pivot tables??

JPG
 
S

ShaneDevenshire

Hi Juan,

Choose Tools, Protection, Protect Sheet, and put a check beside the User
PivotTable Report option. (2003)
 
J

juanpablo

Hi,

But I have tried doing that, and the option of update data in pivot table
still dissapears. I dont want to unprotect every time I use the table.


JPG
 
S

ShaneDevenshire

Hi Juan,

Worksheet Protection block Refresh. You're only solution that I know of is
to create a VBA macro which runs the refresh command after it unprotects the
sheet and then reprotects it.

Sub RefreshPT()
ActiveSheet.Unprotect Password:="x"
Set pvtTable = ActiveSheet.Range(ActiveCell.Address).PivotTable
pvtTable.PivotCache.Refresh
ActiveSheet.Protect Password:="x"
End Sub
 
Top