What is your formula? What are the input values? What result did you expect
and what did you get instead?

Kind regards,

Niek Otten

"jefftlewis" wrote in message
...

I am working with a circular file. I have been making changes to the
file,
and I have noticed at times when i manually calculate that the file
iterates
to an obviously "incorrect" solution.

No amount of changing the max no of iterations or the max change seems to
fix the problem. It iterates to the same "incorrect" solution every time.
It is like it is stuck in a rut and can't get out.

I have also noticed that, if I manually calculate each worksheet
separately
(that is, hit shift - f9 simulaneously on each worksheet individually,
from
left to right) all the worksheets seem to calculate correctly. This leads
me
to believe that the file can calculate perfectly fine, and that the issue
is
with how excel iterates when it is asked to "globally" iterate (when I
just
hit f9 and let excel do its thing).

Am I doing something wrong here? Any know how to fix this?

Regards,
Jeff