call dll's from Excel asynchronously ?

  • Thread starter Emile Besseling
  • Start date
E

Emile Besseling

Hello,

I have an Excel Addin, in which I call an DLL which retrieves data from a
Iseries application.

In Excel the cells contain an formula which is fed to the DLL. This works
great except when using
lots of cells and formula executiontime takes a while because Excel
(re)calculates the cells one by one.

Is it possible and how to that Excel calculates the cells not one by one but
asynchronously, for example
5 at a time ? This would decrease the recalculationtime.

Other suggestions to speed up are also welcome !

Best regards,

Emile Besseling
(e-mail address removed)

(remove geenspam)
 

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

Making customized asynchronous function 0
32 bit DLL with 64 bit Excel 2010 13
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Unable to call a DLL function from Excel 1
Making Changes to Cells from a user defined function 3
Do I need DLL or COM Addin, Excel Addin 1
problem with "file not found" calling a dll from VBA 6
Calling a DLL 1

Top