Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
update protected cells
i hope I am posting in the correct forum.
I have a sheet in which I have 4 areas to enter data and at the end of each area the rows and columns have running totals. How do I protect and unprotect the sheet in order to update the cells that carry the running total after each input is done? Thanks in advanced. Hernan. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
update protected cells
The formulas in the protected cells will update as you enter new data so no need
to unprotect. Are you having an issue with the formulas not updating? Maybe you have calculation mode set to manual? Gord Dibben MS Excel MVP On Sat, 27 Oct 2007 08:06:01 -0700, Hernan wrote: i hope I am posting in the correct forum. I have a sheet in which I have 4 areas to enter data and at the end of each area the rows and columns have running totals. How do I protect and unprotect the sheet in order to update the cells that carry the running total after each input is done? Thanks in advanced. Hernan. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
update protected cells
Thank you! I did not even notice about being in manual mode...
Hernan "Gord Dibben" wrote: The formulas in the protected cells will update as you enter new data so no need to unprotect. Are you having an issue with the formulas not updating? Maybe you have calculation mode set to manual? Gord Dibben MS Excel MVP On Sat, 27 Oct 2007 08:06:01 -0700, Hernan wrote: i hope I am posting in the correct forum. I have a sheet in which I have 4 areas to enter data and at the end of each area the rows and columns have running totals. How do I protect and unprotect the sheet in order to update the cells that carry the running total after each input is done? Thanks in advanced. Hernan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected Sheet doesn't update linked information | Excel Discussion (Misc queries) | |||
Opening Protected EXCEL worksheets to update linked data | Excel Discussion (Misc queries) | |||
Opening Protected EXCEL worksheets to update linked data | Setting up and Configuration of Excel | |||
Opening Protected EXCEL worksheets to update linked data | New Users to Excel | |||
Allow custom update button to work while sheet is protected | Excel Discussion (Misc queries) |