UDF triggered when not required

Add-in Express™ Support Service
That's what is more important than anything else

UDF triggered when not required
 
Ranjitha Nagendra




Posts: 40
 Joined: 2015-10-26
Hello addin express team

I have created an XLLModule, and I have 10-15 functions added under my function category. I use ADXExcelRef object within. But anything typed in any excel cell is triggering all the functions added in that excel workbook and it starts calculating all the functions. Anything I have to set to stop this behavior so that a function is executed only when requested?
Ranjitha
Posted 20 Sep, 2016 02:00:23 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Hello Ranjitha,

This occurs if you set the IsVolatile property on the corresponding function descriptor to true. Another variant (and a solution) is described in https://www.add-in-express.com/forum/read.php?FID=5&TID=9658.


Andrei Smolin
Add-in Express Team Leader
Posted 20 Sep, 2016 02:14:08 Top
Ranjitha Nagendra




Posts: 40
 Joined: 2015-10-26
That works very well, thanks a lot for the quick response.
Ranjitha
Posted 20 Sep, 2016 02:32:10 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
You are welcome!


Andrei Smolin
Add-in Express Team Leader
Posted 20 Sep, 2016 02:45:50 Top