Formula changes

[Jonathan589]

XL2003. I have a simple little workbook where I add six numbers to a little
column of prepared cells every month in rows 5:9, column R one month, S the
next and so on. The sixth number is the received total, so I have a check
further down that adds (say) R5:R9 and should naturally get the same answer
as that sixth one in R10. The trouble is that as soon as I tab out of that
sixth cell the check sum formula morphs to SUM(R5:R10). Why?

I catch the error here, but I'm nervous that it might happen elsewhere in a
not-so-obvious way.

 

[Exceleration]

Jonathan,

I am using 2002, so yours may be a bit different. But I suspect your problem
lies here:

Go to Tools -> Options -> Edit Tab -> Uncheck "Extend List Formats and
Formulas"

John

 

[Jonathan589]

Thanks for this John. The XL2003 equivalent is "Extend data range formats and
formulas" and turning it off fixed my Little Problem. I will now investigate
the point of this option!