Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protecting formula cells in excel 2003
users are writing over the formula cells so im
trying to protect the formula cells in excel 2003 and not having a lot of luck. when i protect the formula cells, they quit working-it disables the formulas. if i protect the sheet, then i cant do data entry in the non-formula cells. this is frustrating. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
protecting formula cells in excel 2003
Go under Tools...Protection
There is a bunch of options wrote in message oups.com... users are writing over the formula cells so im trying to protect the formula cells in excel 2003 and not having a lot of luck. when i protect the formula cells, they quit working-it disables the formulas. if i protect the sheet, then i cant do data entry in the non-formula cells. this is frustrating. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
protecting formula cells in excel 2003
the "options" that you refer to do not address the problem of the
formula cells no longer working when they are protected. here it is again, when the formula cells are protected , according to the instructions eg protecting the cells using the format options then protecting the sheet, the formulas QUIT WORKING !!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003 Formula Bar | Excel Discussion (Misc queries) | |||
sum formula not working, producing incorrect answers Excel 2003 | Excel Discussion (Misc queries) | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) |