In Excel VBA, we can create a non-volatile UDF as follows:
[https://learn.microsoft.com/en-us/office/vba/api/excel.application.volatile]
Function My_Func()
Application.Volatile = False
...
End Function
Is there a way to create a non-volatile Python UDF in Excel? Excel becomes very slow because my Python UDF gets recalculated even when the inputs are not changed. It will be great if there is a way to make the Python UDF non-volatile. Could you please show me how (or add as a development item if we can't currently do it)?
In Excel VBA, we can create a non-volatile UDF as follows:
[https://learn.microsoft.com/en-us/office/vba/api/excel.application.volatile]
Function My_Func()
Application.Volatile = False
...
End Function
Is there a way to create a non-volatile Python UDF in Excel? Excel becomes very slow because my Python UDF gets recalculated even when the inputs are not changed. It will be great if there is a way to make the Python UDF non-volatile. Could you please show me how (or add as a development item if we can't currently do it)?