Excel sometimes not Calculating???

[Ken]

Excel2003 ...

Is there a reason why certain Formulas in a spread sheet would just quite
working? Formulas have worked fine for sometime & now they do not calculate.

Note: This has only started recently & on more than 1 spread sheet ... Some
Cols calculate & others do not ...

Any hints? ... Thanks ... Kha

 

[Max]

Rule out the usual culprit, calc mode set to Manual
Click Tools > Options > Calculation tab
Check > Automatic > OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik

 

[Ken]

Max ... (Good morning)

The "culprit" was me ... Formulas were working fine ... Section of ws I was
looking @ appeared blank ... However, Formula was returning a null ("") for
this particular section of the ws ... If I had just scrolled down (which
eventually I did) I would have seen Formulas working as intended ...

Just another fine example of "dead line" brain cramps ...

Thanks for supporting these boards ... Kha