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