Hi Don,

There are several known limitations of Range.calculate with Excel 2002.

Maybe you have hit one of them: see
http://www.DecisionModels.com/calcsecretsg.htm


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Don Wiss" wrote in message
...
I have applications in active use in my company that under macro control
just calculate a single cell, or a range. I figure that I don't need to
calculate the entire workbook when I don't need to. Usually this works
fine. Every once in a while it doesn't. Once a workbook gets into such a
state the only solution is to delete the range and do a calculate on the
entire workbook. The one I saw today, and which motivated me to post,
there
was no other workbook open. Have others seen this? Any idea why?

We are using xl2002.

Don <donwiss at panix.com.