Hi,

What version of Excel are you using? Are you using any user defined
functions?

I found the following in a Google groups search on "excel formulas do not
calculate":

http://groups.google.com.au/group/mi...7fee234aa2f9bf

http://groups.google.com.au/group/mi...7fee234aa2f9bf

http://groups.google.com.au/group/mi...a5c1e56b899e4a

Hope this helps.

Sean


"Karthik" wrote in message
oups.com...
Hi All

I have been using excel for few years now but have never had this
problem... Wonder if anyone has any tips on my problem.

I have a file which has 15 sheets and the 15th sheet is sum of the
remaining sheets. In all I have used 70 columns and 250 rows in all
sheets. The problem is that the 15th sheet (which is a sum sheet) is
not getting updated once the changes are effected on dependant sheets.

I have checked and rechecked the claculation mode to be in Automatic
and also switched between Automatic and Manual calculation mode several
times.
Restarted Excel as well as my comp several times.
Tried using F9 key......

all this but the sum would not change. And I am forced to go and hit
the F2 key and then press Enter Key for each of the cells in the sum
sheet and only then the valuse get updated.

Has anyone gott an I dea as to what might be wrong...

Thanks in advence
Karthik Bhat