Graphs lose data when I double click!

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

Guest

Hi.
I've created a macro that updates the data in existing graphs in a powerpoint file. However, when I close the file and re-open it, the data reverts back to its original. If I run the macro and then double click the graph BEFORE closing the file, then the new data is saved and I don't have the problem.

I need to work out how to make my macro work so the new data is saved even without me manually double-clicking on each graph. Any help would be greatly appreciated!
 
Use the graph application's .Update method before closing the graph app.

That updates the copy of the data held in the ole container app. Without an
update, you're closing the copy of the data in Graph's memory w/o saving it
and reverting to the original data.

--
Posted to news://msnews.microsoft.com
Steve Rindsberg, PPT MVP
PowerPoint FAQ - www.pptfaq.com
PPTools - www.pptools.com
===============================

Doodles said:
Hi.
I've created a macro that updates the data in existing graphs in a
Click to expand...
powerpoint file. However, when I close the file and re-open it, the data
reverts back to its original. If I run the macro and then double click the
graph BEFORE closing the file, then the new data is saved and I don't have
the problem.
I need to work out how to make my macro work so the new data is saved even
Click to expand...
without me manually double-clicking on each graph. Any help would be
greatly appreciated!
 
Back
Top