TOOLS
OPTIONS
EDIT Tab
Uncheck "Extend data range formats and formulas"
OK

HTH,
Elkar


"Geoff C" wrote:

Excel 2003. Have two columns in a worksheet. Column P is for data entry. The
cells in Column Q sometimes (but not always) contain a formula that returns a
message depending on the content entered into the same row in Column P. That
formula is not always the same, but sometimes there are sequences where the
formula repeats for a while.

The problem; say a sequence has cells Q1 and Q3 containing the same formula,
but Q2 empty. When I enter 1,1,1 into cells P1, P2, and P3, Excel takes it
upon itself to decide that I want a copy of the formula in Q1 created in Q2.
I don't! The fact that there is another 1 in P2 is a coincidence.

I don't know where this behaviour came from, it's a recent thing when we got
computer upgrades. Is there an option I can turn off or on to suppress this?
Any other suggestions how to fix this? Its causing big headaches, because
the unwanted formulae return messages that don't make sense, and confuse the
users.

Many thanks,
Geoff.