refresh excel charts in power point

[just_some_guy]

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!