Hi,

I have a large spreadsheets which has changed to Itterations and
manual calculation. I have just upgraded from Excel 2000 to Excel
2003 and have a relatively large model approx 20MB's.

My problem is that in some cases I will have a cell say CR55 which is
a sum of the numbers above it and displays a value of 10. Then I have
another cell CS54 which is =CR55 however the value comes up as 15 when
it should come up as 10. To further test the situation I went to
another cell on the sheet and made this = C55 and the right value of
10 shows up.

When I go to calculate sheet the error corrects itself. However when
I hit F9 the error occurs again. Basically I'm getting two different
results depending on how I calculate. (F9 or Calculate sheet). The
problem is that the end result that my output is on a different sheet.
The problem is on Sheet 1 and this number is used on sheet 2 and
sheet 2 is used to calculate a number on Sheet 3 which is used to
calculate output on sheet 4. It is not feasible to calculate every
sheet in the workbook all the time.

This problem didn't happen in Excel 2000. However once opened in 2003
and then re-opened in 2000 the problem persists. However if I goto a
backedup version of the model that was never opened in 2003 and open
in 2000 the problem is non-existant and everything is "perfect"!

Thanks
Kulwant