Block Cell

  • Thread starter Thread starter juanpablo
  • Start date Start date
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
 
Hi Juan,

Choose Tools, Protection, Protect Sheet, and put a check beside the User
PivotTable Report option. (2003)
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing Pivot Table on a protected spreadsheet tab 1
Formats 8
Sharing workbooks limitations - Merged Cells 12
Excel VBA For excel 0
Displaying arrow in a dropdown list within cell 2
Adding to an existing Pivot Table 7
Pivot Table Ranges 8
Question on the occupied field of the pivot table in excel spreadsheet 0

Back
Top