Simple +formula not reading value from the reference cell

[Richard Buttrey]

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
__________________________

 

[Tom Ogilvy]

What happens when you do

Ctrl+Alt+Shift+F9 or Ctrl+Alt+F9

 

[Richard Buttrey]

What happens when you do

Ctrl+Alt+Shift+F9 or Ctrl+Alt+F9

Mmmm... Thanks Tom.

Both of those cause the cell to re-calculate to the correct number.

Have you any idea why the workbook is not automatically
re-calculating? Automatic calc is enabled . It all seems a bit weird,
I've never come across anything quite like it before.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Tom Ogilvy]

If you are using xl97 and the workbooks contains a UDF, it is possible the
calculation stream is being interupted by an error in the UDF. I believe
newer version were more robust, but this is the possibility that comes to
mind.

You might go to Charles Williams' site and see what he has

http://www.decisonmodels.com

he has some pages of discussion on calculation.

 

[Richard Buttrey]

If you are using xl97 and the workbooks contains a UDF, it is possible the
calculation stream is being interupted by an error in the UDF. I believe
newer version were more robust, but this is the possibility that comes to
mind.

You might go to Charles Williams' site and see what he has

http://www.decisonmodels.com

he has some pages of discussion on calculation.

Thanks Tom, I'll go and have a look. I'm actually using Excel 2002

Note for info. If anyone else is following Tom's link, please note the
typo. it should be

http://www.decisionmodels.com

Regards

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________