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

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

Hi

I also have a problem with charts calculating in Excel 2003. The chart
only refreshes with current data when I exit the file and then reopen.


It is quiet a complex spreadsheet, and is showing the 'Calculate'
message at the bottom of the screen. I have tried several times to do a
full rebuild using Crl Atl F9.

thanks in advance
Peter


--
PeterW
------------------------------------------------------------------------
PeterW's Profile: http://www.excelforum.com/member.php...fo&userid=6496
View this thread: http://www.excelforum.com/showthread...hreadid=395289

The only workaround I have at the moment is to pretend to resize a column
width(to its current width). For some reason this seems to work.

"PeterW" wrote:


Hi

I also have a problem with charts calculating in Excel 2003. The chart
only refreshes with current data when I exit the file and then reopen.


It is quiet a complex spreadsheet, and is showing the 'Calculate'
message at the bottom of the screen. I have tried several times to do a
full rebuild using Crl Atl F9.

thanks in advance
Peter


--
PeterW
------------------------------------------------------------------------
PeterW's Profile: http://www.excelforum.com/member.php...fo&userid=6496
View this thread: http://www.excelforum.com/showthread...hreadid=395289

thanks Richard

I have also since found that reordering the data series seems to work


--
PeterW
------------------------------------------------------------------------
PeterW's Profile: http://www.excelforum.com/member.php...fo&userid=6496
View this thread: http://www.excelforum.com/showthread...hreadid=395289