Do you have an event macro that may be changing the cell?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Steve Peel" wrote in message
...
No, the formula is only 2 columns away on the same sheet...

"smartin" wrote:

Steve Peel wrote:
My simple formula referencing the value of another cell is written over
by
that value when the value of the referenced cell is changed? This is a
strange question for me to ask because I have been working with excel
for
over a decade and have never come across this before

Is the referenced cell in another workbook? That is the only way I know
for a formula to be overwritten by a value -- and then only when the
link to the external workbook is broken.