It is Excel 2007.
I have 2 GB RAM, Quad Core machine with 200GB HD, hardware does not seem to
be the problem.
Logic been through it a million times, the complex formula is complicated
because there are many exceptions to get to the answer, I have broken it down
to their minor sections and pieced it all back together, used AND OR (nested)
to cut down on the number of IFs statements.. so I don't think thats the
problem.
I think Joe may have explained it, it may have to do with MSE looking
through every cell and formula on opening to generate the dependency graph.
I'll research it some more. Thanks for the help.

Henry


"Bill Sharpe" wrote:

Excel version?
How much free memory?
How fast is your processor?
Short on HD space?
94 mb is somewhat excessive. There must be some way to clean up your logic.

Bill