Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.de.excel,microsoft.public.office.developer.vba,microsoft.public.excel.programming
|
|||
|
|||
range.calculate error - -2147417848
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 |
#2
Posted to microsoft.public.de.excel,microsoft.public.office.developer.vba,microsoft.public.excel.programming
|
|||
|
|||
range.calculate error - -2147417848
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/new...lic.excel.misc Please send (possible) answers to my email-account ) 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!) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automation error '-2147417848 (80010108)' excel 2007 | Excel Discussion (Misc queries) | |||
error: 2147417848 | New Users to Excel | |||
How to calculate with #div/0! error? | Excel Worksheet Functions | |||
Run time error 2147417848(80010108) | Excel Programming | |||
Range.cells.calculate give error 1004 only in XP | Excel Programming |