Problems with Excel/C++

konovs · July 14th, 2002, 7:39 pm

Did anybody every run into this problem? I have written a function in C++ and calling it from Excel. When I first open the Excel document with the function already in it, it calculates instantly. When I try to recalculate or change any of the variables it takes forever to process. I am using Visual Studio. NET and Excel XP. Would greatly appreciate any suggestions.

mholm · July 15th, 2002, 10:44 am

Managed or unmanaged?

konovs · July 15th, 2002, 4:32 pm

What do you mean?

PinballWizard · July 15th, 2002, 5:56 pm

What he means is: Since you're using Visual Studio.NET, is your C++ code 'managed' a la .NET or is it 'unmanaged' (i.e. does not make use of the .NET Framework) ?We really need more details to be able to help you: - how and when is your C++ function called from within Excel ? - is the call wrapped inside a custom Excel VBA function, which is then used in your worksheets ?