I seem to have amazing disappearing Excel charts and I need to find
out how to prevent them from disappearing.
My process starts in Access. A VBA procedure in Access opens an Excel
workbook as a template in the background. Data is plugged into a
worksheet named "Data." Then Access calls a macro in the Excel
template workbook which changes SERIES formulas for four different
charts on four different worksheets. Then the program updates the
colors on the bars of the bar charts. Once that is done, Access saves
the template as a finished report and makes the workbook visible.
The problem is that when the Excel workbook becomes visible the charts
are invisible. I can find the frame of the chart but the contents are
However, when I close the workbook and re-open it the charts are
there, and they are perfect.
Do I need to run a VBA command like a Refresh or Requery or Repaint or
something like that to make the charts appear without having to close
and re-open the workbook?