The problem was arising because I was attatching to a particular event of the
third party com control, after attaching to a "later" event the problem was
resolved. This doesn't however explain why it happened or why the version of
office was an issue.

"Richard Bond" wrote:

Hello,

I have an embedded chart linked to cells on the same worksheet. These cells
get their values from a third party com object via a function:

e.g. =BCell("TNS_1100_01","[2]","[1]")

In excel 2000 the chart reflects the source data, but in 2002 and 2003 they
don't.

If I manually type an absolute value in the cells then the chart will update

Calculation is set to Automatic, I have hit "calc now" several times, run
application.CalculateFull and a chart.refresh.

Their is also a similar problem with linked textboxes.

I have seen one post that said if a calculation fails, then this may occur?
how do I test for this, and does it seem like this could reeally be the
problem???

please help,

regards,

Richard