View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default error in sum-ajit

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