refresh excel charts in power point

Being new, I'm not sure if it was ok to discuss power point, even in the "off topic" section.

If it's ok, then I had a question, and maybe someone can help me with it. My boss has a power point presentation that links with Graphs from a few excel workbooks, spread over 15 or 20 slides. In power point 2007 there is a "refresh" button for the graphs. If you hit it, it pulls the more current version of the graphs from the workbooks.

My boss would like a macro that goes through and updates each graph. Unfortunately, I'm still very early in learning anything VBA related, so I'm having trouble writing the macro. And of course, there is no macro recorder in 2007.

I thought "hey, there is still one computer that has 2003 on it" and went to try to record the macro on there. Unfortunately, I can't seem to find the "refresh" button for the graphs anywhere in 2003.

So, my question(s) at last. Does anyone know where the "refresh" button for the graphs might be in 2003? Failing that, does anyone know what the VBA code might look like for that in 2007?

Lastly, if it's not alright to discuss power point, is there a good site to find what I'm looking for?

Thanks!

Derek,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

Assuming the chart is an copy/linked chart from a separate xl file then the following with the chart selected should work.

application.CommandBars.ExecuteMso "ChartRefresh"