There are references to other workbooks within this workbook, but not on this
sheet, and the links are not broken....

"smartin" wrote:

Steve Peel wrote:
smartin" wrote:
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.

No, in fact it is only 2 colums to the right???

Hi Steve,

And 2 columns to the right, as you say, you have no external references
there either (or dependent references to the same)?

IOW, are there references to another workbook anywhere here that might
be breaking?