| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to setup refreshable crosstab in a protected sheet?
I have a worksheet with a crosstab that start at cells F1. I would like to
lockout only the cells is range A1:D10 , protect the sheet and still allow for all users to refresh the data in the crosstab. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to setup refreshable crosstab in a protected sheet?
My question should read How do I setup a refreshable cross tab (pivot table)
in a protected sheet? Also is it possible to do this and disallow deletion of the pivot table? "Ruby Christine" wrote: I have a worksheet with a crosstab that start at cells F1. I would like to lockout only the cells is range A1:D10 , protect the sheet and still allow for all users to refresh the data in the crosstab. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to setup refreshable crosstab in a protected sheet?
OK Found the answer in question/title "Worksheet protection with exceptions"
http://www.microsoft.com/communities...994&sloc=en-us Thanks "Ruby Christine" wrote: I have a worksheet with a crosstab that start at cells F1. I would like to lockout only the cells is range A1:D10 , protect the sheet and still allow for all users to refresh the data in the crosstab. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| How to paste objects in a protected sheet | Excel Discussion (Misc queries) | |||
| Down arrow moves cursor to top of worksheet when sheet protected | Excel Worksheet Functions | |||
| is it possible to use macros when the sheet is protected | Excel Discussion (Misc queries) | |||
Linear Mode
