Block Cell
 

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

JPG

Block Cell
 

Hi Juan,

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


"juanpablo" wrote:

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

JPG

Block Cell
 

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

"ShaneDevenshire" wrote:

Hi Juan,

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


"juanpablo" wrote:

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

JPG

Block Cell
 

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

--
Cheers,
Shane Devenshire


"juanpablo" wrote:

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

"ShaneDevenshire" wrote:

Hi Juan,

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


"juanpablo" wrote:

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

JPG