Hello experts,

we are running a very complex simulation in Excel 2000, with an external
XLL linked.

The probelm right now is, that some cells with array formulas can not
be calculated out of VBA using worksheet.range.calculate. The errormessage
is

Runtime error '-2147417848 (80010108)'
Method 'calculate' of object 'Range' failed

Inside the cells are array formulas which calls functions in our XLL.
This error occures only sometimes (randomly) and we are not able to
reproduce the error. The cells can be calculated out of Excel manually
and are beeing calculated out of VBA most times.

When the error arises, VBA stops but Excel seems to be dead. Only stopping
with the taskmanager is possible.

I tried to debug the XLL, but the error does not occure if I run the simulation
out Excel started by the debugger.

We have the same problem using Excel 2000 with SP1 and SP3.

Please send (possible) answers to my email-account )
as well.

Thanks in advance.


Stephan Kostial