In excel, if I have a chain of dependancies through a series of cells, changing the first cell (the root) of the dependancy correctly triggers recalculation.I have a problem with this when using an XLL I have written in c++. My (simplfied*) xll contains a double, and two methods setNumber(double) and double getNumber(). I want to do the following:A1: some numberA2: setNumber(A1)A3: getNumber()This works fine at first, but does not recalculate properly. In fact, if you trace dependancies, A3 does not appear to depend on anything (which i understand, just do not like). So, when I change A1 I have to manually go and recalculate A3. ctrl-alt-f9 does not help, and anyway - I want to understand this. If there is a massive montecarlo lurking somewhere, I can't just recalc trivially.Q: Can I for force Excel to recognise non-obvious dependancies?Q: If not, what can I do?Thanks for reading, hens*Actually, my dll contains a quantlib objecthandler

Just define A3 to be getNumber()+0*A1. You can even use Excel's Find and Replace All to modify all formulas with "getNumber(" in them.If you have a large number of input parameters in which a change in any should trigger a recalc, then define a cell as the sum of these parameters times zero and then reference that dependent cell in all the cells that make an untraceable call.

That's a nice solution. Thanks!

QuoteOriginally posted by: Traden4AlphaJust define A3 to be getNumber()+0*A1. You can even use Excel's Find and Replace All to modify all formulas with "getNumber(" in them.If you have a large number of input parameters in which a change in any should trigger a recalc, then define a cell as the sum of these parameters times zero and then reference that dependent cell in all the cells that make an untraceable call.Just define A3 to be getNumber, it is a really good tip for me, Thanks.

QuoteQ: If not, what can I do?Go read up on volatile and non-volatile functions in Excel. Non-volatile functions are re-evaluated only when one or more of the function arguments change; Volatile functions (like Now() and Rand()) are re-evaluated every time the worksheet is calc'd. If getNumber() really is just a getter for an existing number, make that function volatile.

how do u incorporate a customised function in C++.. into MS excel through dll/xll??? i have tried everthng... doesnot work though... please help me out....tried using sample codes on net... still does not work...