I wanted to designate some functions as volatilie so they will recalculate each time the spreadsheet is recalculated, regardless whether their arguments have changed. According to Microsoft's documentation I should be able to this by inserting
first thing in the function. However, Microsoft's example is in VB only and I am using C#. I tried this in my ExcelDNA using the following code inside my function:
Excel.Application app = (Excel.Application)ExcelDna.Integration.ExcelDnaUtil.Application;
return GetHfaData(itemType, itemID, CodeName);
but it does not seem to make any deifference in the recalculation behavior. Should this work with ExcelDNA, or is there another method to designate that a function is volatile?