| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't edit cell
I'm trying to just add a simple formula to a cell in Excel "=sum(A1,
I1)" but unfortunately it seems to keep coming back with an error: "Cell contains a Formula. Cannot Modify. Must Select Cancel." I tried searching for this error but I came up empty. Anyone have any ideas on what I am doing wrong? Thank you, Dave |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't edit cell
sounds like the cell is locked with a custom validation.......
i do that a lot with mine, so users can't change my perfectly-planned-formulas. :) on the main toolbar, try data........... validation............ & see if anything is already entered there or if it's all blank. susan DRLski wrote: I'm trying to just add a simple formula to a cell in Excel "=sum(A1, I1)" but unfortunately it seems to keep coming back with an error: "Cell contains a Formula. Cannot Modify. Must Select Cancel." I tried searching for this error but I came up empty. Anyone have any ideas on what I am doing wrong? Thank you, Dave |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't edit cell
that looks like it worked, thanks.
Dave Susan wrote: sounds like the cell is locked with a custom validation....... i do that a lot with mine, so users can't change my perfectly-planned-formulas. :) on the main toolbar, try data........... validation............ & see if anything is already entered there or if it's all blank. susan DRLski wrote: I'm trying to just add a simple formula to a cell in Excel "=sum(A1, I1)" but unfortunately it seems to keep coming back with an error: "Cell contains a Formula. Cannot Modify. Must Select Cancel." I tried searching for this error but I came up empty. Anyone have any ideas on what I am doing wrong? Thank you, Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Attempted edit of protected cell jumps user to another cell | Excel Discussion (Misc queries) | |||
| Disable cell reference insertion with PageUp in cell edit mode. | Excel Discussion (Misc queries) | |||
| How do I edit a cell in Excel without clicking on the cell first? | Excel Worksheet Functions | |||
| protect specific cell but allow edit on other cell | Excel Worksheet Functions | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
Linear Mode
