Charts not updating in 2002,2003 but working in 2000
 

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

Charts not updating in 2002,2003 but working in 2000
 

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

Charts not updating in 2002,2003 but working in 2000
 

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

Charts not updating in 2002,2003 but working in 2000
 

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

Charts not updating in 2002,2003 but working in 2000
 

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