Hi,
Can you tell me how can I force Excel to recalculate all my functions? The obvoious solution (Application.Calculate) does not help, as it (from some strange reason) does not recalculate those of my UDFs, which calls an external DLL. (Nor will the values of these cells are actualised, when I press F9 (recalculate). The only way I can force recalculation of those UDFs with DLL calls, to modify any of the input parameters / or I close and reopen Excel. (I do not want to define these functions as volatile as I do not want them to recalculate permanently, only at some occasions. Any idea?
Thanks,
hege