Excel sometimes not Calculating???
 

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

Excel sometimes not Calculating???
 

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" wrote:
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

Excel sometimes not Calculating???
 

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



"Max" wrote:

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" wrote:
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