No. I checked the toolsoptionsCal 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?
--
Knowldege is Power


"Ron Coderre" wrote:

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)

"Ajit Munj" wrote in message
...
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
--
Knowldege is Power