Thread: Can't edit cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default 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