Stale handles from objectHandler?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Stale handles from objectHandler?

rohan talwar
Hi, I am a new member of the quantlib user group, and new in general to this type of thing. I am not sure how to address this group, as I don't know who will answer.

My setup is a folllows:
OS=Windows Vista (32bit)
XL = 2010

I have written a worksheet which is fairly complicated by my own admission, and I am having troubles with stale handles or something like that. I think there is some issue with dependency tree/calc tree. When I full calc a sheet (the workbook), many cells do not update. When I visit an individual cell (recalc via F2) the value is updated. Prior to that it is #NUM! and there is no error - ie F2 provides value. I have a large table of values, which seems to never update.

Also, I am trying to remove explicit trigger params, since I do not manually reference objects, but do so via reference (to cells). Does this affect performace - vis-a-vis dependency tracking and the calc tree?

There are some related queries, but I will leave these for follow on.

Kind regards
Rohan Talwar



------------------------------------------------------------------------------
Gaining the trust of online customers is vital for the success of any company
that requires sensitive data to be transmitted over the Web.   Learn how to
best implement a security strategy that keeps consumers' information secure
and instills the confidence they need to proceed with transactions.
http://p.sf.net/sfu/oracle-sfdevnl 
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users