error in sum-ajit

[Ajit Munj]

I am summing the values in cells e5:ai5 but shocking to see that though I
change the values in this range the sum does not change? What's wrong? (Excel
97). Pl. help

 

[Ron Coderre]

It sounds like you have Calculation set to Manual.

Try this:

From the Excel Main Menu:
<tools><options><calculation tab>
....Check: Automatic

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Stephen]

I am summing the values in cells e5:ai5 but shocking to see that though I
change the values in this range the sum does not change? What's wrong?
(Excel
97). Pl. help

Tools > Options > Calculation tab
Is Calculation set to manual? If so, choose automatic.

 

[David Biddulph]

Tools/ Options/ Calculation
Set to Automatic, not Manual.

 

[Ajit Munj]

No. I checked the tools>options>Cal Tab it is already set to automatic. after
opening the file, the sum changed only once or twice. But afte that it does
not change even the fig. in the range has been changed. Anything else going
wrong?

 

[joeu2004]

No. I checked the tools>options>Cal Tab it is already set to automatic. after
opening the file, the sum changed only once or twice. But afte that it does
not change even the fig. in the range has been changed. Anything else going
wrong?

Did you execute any macros or user-defined functions?

 

[Ajit Munj]

No, I donot run any macros or use-defined function. But yes, while saving
file, a message flashes saying "The file was created using later version of
MS Excel.If you save this file using MS Excel 97, information created with
features in the later version may be lost". Is this the reason?