I have some macro equivalent functions with xl_cell arguments that I want to write, but I need them not to be volatile.
In Microsoft's documentation (https://msdn.microsoft.com/en-us/library/office/bb687891.aspx
), they have this explanation:
By default, Excel handles XLL UDFs that take range arguments and that are declared as macro-sheet equivalents as volatile. You can turn this default state off using the xlfVolatile function when the UDF is first called.
But the xlfVolatile function does not appear to be exposed in PyXLL. This is unfortunate because I suspect that might solve the problem: in Excel-DNA, which is a free PyXLL-equivalent product for MS Visual Studio, it is exposed and seems to work as intended (i.e. my Range macro-equivalent functions are not volatile).
Is there a work-around? I have tried calling xl_app.Volatile(False) in my PyXLL UDF but it seems to have no effect.
Any help would be greatly appreciated! Thanks