Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm using Excel 2003
I have values in cells A1, B1 and C1 I have a formula in cell G1: =SUM(A1:C1) I type a value in cell D1 and Excel 2003 automatically changes the formula in cell G1 to =SUM(A1:D1), without any notification How can I prevent this automatic changing of the formula in cell G1? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i restrict users from changing my formulas | Excel Discussion (Misc queries) | |||
Automatic absolute formulas | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |