guilbj2 wrote:
It's likely a buffer overflow error caused by your clipboard not being
cleared. Something running for that long can easily cause this type of
issue. I imagine the crashes only occur if it's been running for an
extended period. If not, please update and include any error messages
you're receiving.



There are no error messages. Excel just goes silent and sits quietly
frozen doing nothing. If I invoke the XP task manager it simply says
that Excel is not responding. The only way out of the situation is to
kill Excel and restart it from scratch.

I do not use the clip board for anything in this program. However, is
there some VBA command I could use to flush the clip board periodically
to verify this is not a problem?

The system will never crash if Excel is the only thing running so I
wouldn't think it's some simple buffer overflow caused by Excel alone.
On the other hand there may be some problem with Excel storing away it's
buffers as XP switches the task about?

If I run other simple tasks, Excel may freeze up immediately or in two
hours or never. I do not see this Excel behavior though while I have
other spreadsheets active -- which of course aren't doing anything but
sitting passively anyhow. I don't have any other spreadsheets that take
extended time to run. Perhaps I should create another one that does
nothing but burn execution cycles and see how stable that is....

Bill