I have a customized Excel User Defined Functions (udf) that gets data from a database to the Excel Sheet. when I execute this function (=getData(A1,B1)) from a c# code to get data on an excel file, it will be put on a cell without being executed until i manually open the file . here is a part of my code :
Please Login or Register  to view this content.
is there any solution to generate the result automatically and be prevented when the result is generated (it takes a while to get data from database)