Chart objects "losing" data

[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

 

[Steve Rindsberg]

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?

Call the .Update method of the MSGraph application before closing/quitting it.

 

[Shyam Pillai]

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.

 

[Guest]

Steve, Shyam,

Many thanks.... "Update" solved the problem perfectly.

Cheers,
Matt

 

[Guest]

Steve, Shyam,

Many thanks - this solved the problem perfectly!

Cheers,
Matt Stuehler