[QuantlibXL] how to make exported functions non-volatile

Posted by radupaul on Mar 11, 2010; 3:00pm
URL: http://quantlib.414.s1.nabble.com/QuantlibXL-how-to-make-exported-functions-non-volatile-tp9118.html

Hi:

How can I ensure that the functions exported by QuantlibXL are registered with Excel as non-volatile? I understand that somehow I should pass a parameter to the xlfRegister function ?

I am optimizing a big spreadsheet and a large chunk of time is used by re-calculation of volatile functions (without any of the arguments changed).

I appreciate the help (with some details, where should I look, in the QuantlibXLStatic  register folder, etc ...?)
Thank you,
Radu