Re: Embedded Charts NOT updating despite AutoUpdate=1

Despite modifying the underlying data in the Excel spreadsheet of an embedded Chart within a Word doc and setting AutoUpdate val=1 on the ExternalData reference, my chart does not update when I open it in Word. A round trip to Excel via Edit data does update the chart.

What is going on?

This sure looks like a MS bug to me :-(

I have seen a number of other people on this forum complaining of the same problem.

Any workarounds? ...Do I have to update the numCache in the Chart aswel? :-(

Cheers,
Rich.

I am experiencing the same issue. Anybody have a solution?

Yes, you have to update the chart.xml file - that was our "workaround", if you can call it that.  Word will not loop through all of the charts and update them upon opening.

-m

M, thanks for the message. I'm trying to do that, but word is rejecting the updated chart.xml file (it claims the document is corrupted). I don't suppose you have an example of updating the chart.xml file?