title: Refresh all charts without blinking
body: <p>The aim is to refresh all charts in Excel after cells recalculation.</p>
  
  <p>I work with Microsoft Excel 2010.</p>
  
  <p>As we know, there is a bug? in Excel so that Excel does not update charts even after</p>
  
  <pre><code>Application.CalculateFullRebuild
  </code></pre>
  
  <p>A known hack is to do something like this:</p>
  
  <pre><code>Application.ScreenUpdating = False
  Temp = ActiveCell.ColumnWidth
  ActiveCell.Columns.AutoFit
  ActiveCell.ColumnWidth = Temp
  Application.ScreenUpdating = True
  </code></pre>
  
  <p>This does work. However, all Excel charts blink (they become white for a moment while updating). Could you advise, please, is there any way to avoid such blinking?</p>
  
  <p>I tried to call</p>
  
  <pre><code>.Refresh
  </code></pre>
  
  <p>on all charts (<a href="https://msdn.microsoft.com/en-us/library/office/ff198180(v=office.14).aspx" rel="noreferrer">https://msdn.microsoft.com/en-us/library/office/ff198180(v=office.14).aspx</a>):</p>
  
  <pre><code>For Each ChartObject In ActiveSheet.ChartObjects
      ChartObject.Refresh
  Next
  </code></pre>
  
  <p>but for some reason my Excel (2010) shows error #438 "Object doesn't support this property or method".</p>
  
  <p>Could you advise, please, do I miss something important?</p>