Charts not updating in 2002,2003 but working in 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Chart Update While Macro Is Running 4
Automatically selecting active chart 4
Using =Offset in Charts 1
Chart update 1
Excel 2003 VB referencing #N/A not working but works in Excel 2007 1
Simple VBA Code Working in Excel 2007 but not Excel 2003 #N/A 1
Skip the Zeros in a chart 4
Excel to Powerpoint 2003 Chart Width 2

Back
Top