Shift+f9, automatic computation

[Ba-I-T-o]

Hi,

I’ve created a UDF library. Some of the simpler functions take string or flag inputs directly from Excel cells, while others (more complex ones) take a handle that references an object instantiated in memory.

I’m running into an issue with the simple functions: when I open the Excel sheet and press Shift+F9, the functions that depend on other cells recalculate as expected. However, the simple ones (e.g. that just take one or two true/false flags) don’t recalculate. I have to trigger them manually once before they start working with Shift+F9.

Is there a known workaround for this? More generally, does ExcelDna provide any routines or best practices for handling automatic recalculation modes?