On Wed, 6 Jul 2005 16:00:58 -0400, "Tom Ogilvy"
wrote:

If you are using xl97 and the workbooks contains a UDF, it is possible the
calculation stream is being interupted by an error in the UDF. I believe
newer version were more robust, but this is the possibility that comes to
mind.

You might go to Charles Williams' site and see what he has

http://www.decisonmodels.com

he has some pages of discussion on calculation.

Thanks Tom, I'll go and have a look. I'm actually using Excel 2002

Note for info. If anyone else is following Tom's link, please note the
typo. it should be

http://www.decisionmodels.com

Regards

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________