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.