On Dec 9, 9:27 pm, Ajit Munj wrote:
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?

Did you execute any macros or user-defined functions?