Excel 2000 - range.calculate error - 2147417848

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

range.calculate error - -2147417848 1
Runtime Error -2147417848(80010108) 1
'-2147417848' - 'Automation error The object invoked has disconnected from its clients.' 1
Excel 2002 and Visual Basic error message unexpected 0
Copy Paste failed in excel file migrated from Excel 2003 to Excel 1
Adding validation fails with automation error 4
Runtime Error '-2147417848 (80010108)' 3
Excel Bug: Run-time error '-2147417848 (80010108)' 1

Top