S
Stephan Kostial
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.
Thanks in advance.
Stephan Kostial
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.
Thanks in advance.
Stephan Kostial