title: Strange partial refresh of embedded Excel chart in Word
body: <p>I have a Word template with linked, embedded Excel charts. When I create a document from the template, I refresh the charts, first like this in Excel, updating not only data point values but also what data points (what rows of data) are included:</p>
  
  <pre><code>ThisWorkbook.Charts("My Chart").SetSourceData Source:=rgBuilder
  </code></pre>
  
  <p>Then I update the embedded charts in the document created from the Word template like this:</p>
  
  <pre><code>For Each oEmbeddedExcelChart In oDoc.InlineShapes
     oEmbeddedExcelChart.LinkFormat.Update: DoEvents
     oEmbeddedExcelChart.LinkFormat.BreakLink
  Next oEmbeddedExcelChart
  </code></pre>
  
  <p>One of the charts refreshes fine. But another one refreshes only data points, without refreshing changes to what data points (what rows in the data) are included. Depending on the data in any particular run, that sometimes has the bizarre effect of making the chart look in Word like it never looked in Excel.</p>
  
  <p>I tried switching positions of the charts in the Word template, and the problem stayed with the same chart. I tried deleting and recreating the chart, but the new one had the same problem.</p>
  
  <p>Any suggestions?</p>