| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting a block in a cell | Charts and Charting in Excel | |||
| Pasting a block of Word info into a single Excel cell | Excel Discussion (Misc queries) | |||
| Can I insert a cell reference into a block of text? | Excel Discussion (Misc queries) | |||
| comparing a cell to a block off cels | Excel Worksheet Functions | |||
| Cell Block and Furmula Bar display | Excel Discussion (Misc queries) | |||
Linear Mode
