range.calculate error - -2147417848

[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.

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

Thanks in advance.


Stephan Kostial

 

[Monika Weber]

Hi Stephan

we are running a very complex simulation in Excel 2000, with an external
XLL linked. [...]
We have the same problem using Excel 2000 with SP1 and SP3.

Why have you choosen a German spoken Newsgroup?
Here you can find an English one:
http://communities.microsoft.com/ne...LCID=US&newsgroup=microsoft.public.excel.misc

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

Why should we send our answers directly to your e-mail-account?
It could be possible that others here are interestet in the answer too.

--
Greetings,
Monika Weber [Microsoft MVP für Excel]

http://www.jumper.ch (Office Help Desk)
http://excel.codebooks.de (Das neue Codebook ist da!)