Hi Kenneth,
If you control the web API, my general advice would be to:
The Excel-DNA async functions are implemented using Excel’s RTD mechanism.
It’s a rather complicated story how this all fits together, and your questions about timing and the results are returned are intricately related to this implementation.
I give a bit of an overview here, but you might like to set up a support chat with me to go through your case in more detail.
For this we create a wrapper UDF that
Notice that the function is called (at least) twice, and the mechanism depends on the fact that both calls have the same “topic information”.
The mechanism depends on the fact that a function call depends only on the topic information. So if different cells call the same function, with the same arguments, then the topic information will be the same, and they will be considered the same async call. It is possible to add a reference to the calling cell to the list, which will make calls from different cells into different topics. But you can’t split different calls from the same cell into different topics easily, since we need the correlation to complete the async call.
One timing aspect is the throttling Excel does in the step 4(d). Excel will not fetch data from the RTD server too often – there is a setting called the RTD ThrottleInterval that sets how Excel will wait before fetching now data from the RTD Server. You’ll see some discussion of this setting in other discussions on the Google group.
-Govert
--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/a21d9522-d334-4e2e-8566-1b8f24d94849n%40googlegroups.com.