Welcome to the mailing list and apologies for the delay in responding.
Do you have calculation set to manual or automatic? The latter would be the usual choice for a workbook receiving a live data feed.
In a correctly designed workbook, under automatic calculation, any change in inputs should result in an automatic update of outputs (i.e. dependent cells). With calculation set to manual, then after a change in inputs, hitting F9 to invoke an incremental recalculation should be sufficient to update all outputs. You can use Ctrl-Alt-F9 to force a full recalculation of all cells, this is a brute force measure which should not normally be required during production usage, perhaps once just after opening workbook(s). Hitting F2 to refresh individual cells shouldn't be necessary.
If a change in inputs does not result in the
expected change in outputs, this almost certainly points to a flaw in the design of the workbook. I doubt that the versions of Excel and Windows are likely to be relevant. It is a question of ensuring that each formula refers to the cells on which it depends. Usually explicit cell references are preferred, though in some cases triggers might be required, please see
.
> Hi all, I posted this a couple of weeks ago.
> It would be really helpful if someone could let me know whether there are
> additional configuration steps involved with getting the implementation working
> robustly. Particularly whether xl version has anything to do with it, and even
> more remotely, the vista operating system.
>
> Basically, nothing recalcs on a worksheet (reliably - vanilla options, across a
> many point strike structure, calls and puts) - I don't think it is [generally]
> an issue with XL, per se, since any user defined functions work as expected with
> appropriate behavior vis-a-vis dirty precedents [cells].
>
> Would appreciate some help/feedback, as I am at a bit of a standstill. I don't
> want to junk the sheet.
>
> Thanks in advance
> Rohan Talwar
>
>
>
> ________________________________
> From: rohan talwar <
[hidden email]>
> To:
[hidden email]> Sent: Mon, 10 January, 2011 21:48:07
> Subject: Stale handles from objectHandler?
>
>
> 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