Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected Sheets
I am protecting certain cells (Locking) in a workbook that is shared with
many people. I have allowed for them to be able to select locked cells, sort, use Auto filter and edit scenarios and do formating. Everything is working the way we want it EXCEPT we can not use the SUM function. is there a way to do this? -- A |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected Sheets
You can't use the AutoSum but you can type the formula into an unlocked
cell. =SUM(range) =SUM(a1,d3,f4,g6,a4) Gord Dibben MS Excel MVP On Tue, 30 Mar 2010 09:56:10 -0700, Ann wrote: I am protecting certain cells (Locking) in a workbook that is shared with many people. I have allowed for them to be able to select locked cells, sort, use Auto filter and edit scenarios and do formating. Everything is working the way we want it EXCEPT we can not use the SUM function. is there a way to do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected Sheets
Thanks for the response, I figured that out. One more question. Now that I
have everything working and I know that to "sum" I am using the Fx (sum) function. Is there anyway to still allow the Audit tracking - Trace Precedents function ?? -- A "Gord Dibben" wrote: You can't use the AutoSum but you can type the formula into an unlocked cell. =SUM(range) =SUM(a1,d3,f4,g6,a4) Gord Dibben MS Excel MVP On Tue, 30 Mar 2010 09:56:10 -0700, Ann wrote: I am protecting certain cells (Locking) in a workbook that is shared with many people. I have allowed for them to be able to select locked cells, sort, use Auto filter and edit scenarios and do formating. Everything is working the way we want it EXCEPT we can not use the SUM function. is there a way to do this? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected Sheets | Excel Discussion (Misc queries) | |||
Protected Sheets | Excel Discussion (Misc queries) | |||
protected sheets | Excel Worksheet Functions | |||
protected sheets | Excel Discussion (Misc queries) | |||
Protected sheets | Excel Worksheet Functions |