Chart objects "losing" data

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

Guest

All,

I'm using vba to dynamically build a presentation. Several of the pages
contain Chart objects, which are dynamically populated with data. After the
presentation is complete, the script saves the presentation, then closes it.

When I reopen the presentation, the charts all appear as I would expect -
the data is correct. However, if I "open" or "edit" the charts, the data
disappears - the datasheets revert to empty!

Is this a bug? Is there something I can do about it?

Many thanks in advance!

Cheers,
Matt Stuehler
 
Mstuehler said:
All,

I'm using vba to dynamically build a presentation. Several of the pages
contain Chart objects, which are dynamically populated with data. After the
presentation is complete, the script saves the presentation, then closes it.

When I reopen the presentation, the charts all appear as I would expect -
the data is correct. However, if I "open" or "edit" the charts, the data
disappears - the datasheets revert to empty!

Is this a bug? Is there something I can do about it?
Click to expand...

Call the .Update method of the MSGraph application before closing/quitting it.
 
It's a known issue. You need to invoke the Update method prior to calling
the Quit method associated with the graph method. This forces the host
application to update the information within the document.
 
Back
Top