This one has me really puzzled.

Someone has sent me a multisheet workbook, with one of the sheets
named "LORTS".

On another sheet there is a formula which simply reads: =+LORTS!H54

Cell H54 on the LORTS sheet has the formula: =+H46+H52, which
correctly evaluates to 73.

However on the other sheet, the =+LORTS!H54 formula returns the value
76.

Automatic calculation is switched on. The Tools Options Calc Now (F9)
manual calculation has no effect. Yet when I F2 to edit the rogue cell
and enter it back again it changes to the correct value of 73.

Not sure whether it makes any difference, but the designer of the
workbook has also given a range name - also "LORTS", to a range of
cells on the LORTS sheet.

Can anyone suggest what might be happening here - or more accurately
not happening!

I'm using Excel 2003 - SP3

Usual TIA







__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________