Refreshing a set of PowerPoint chart linked to Excel

Question

Hi Folks,

• What is the best way to link Excel charts to PowerPoint slides if you want to be able to refresh the charts via code in PowerPoint?
• I am not a PowerPoint programmer but I do VBA in Access and Excel.  To refresh all the linked charts from inside of PowerPoint via VBA what is the appropriate code approach?  Can I use something like Refresh All or For Each chart in Presentation…. 

Am using Office 2010 under Windows 7.

TIA,

Shane

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

Answer 1

Hi Shane,

Thanks for posting in the MSDN Forum.

I tried to embedded a Excel chart to Presentation via Ctrl+C and Select "Keep source formatting & Link data" on the Slide's context menu. The chart will be update by itself when the Excel's data has been changed.

There seems needn't do anything via code. Please show me more detailed scenario of your goal if it didn't meet your goal.

Have a good day,

Tom

---

Tom Xu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi Tom,

The charts will refresh automatically if the XL files are open at the same time but do the refresh automatically when the files XL files are closed and PowerPoints is opened?

My test shows that you need to manually select each chart and choose Chart Tools, Design, Refresh Data.  That would be fine for one chart but not 120 charts.

Thanks,

Shane 

from Ulaanbaatar, Mongolia

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

Answer 3

Hi Shane,

I will involve some experts who family with it to help you. There might be some time delay, thanks for your patience.

Have a good day,

Tom

---

Tom Xu [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Hi Tom,

Thanks, I will look forward to a reply,

Shane,

from Beijing, China

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

Answer 5

Hello Shane,

Try this line of code:
ActivePresentation.updatelinks

I tried a really simple macro with an embedded linked Excel object in PowerPoint 2010 with this:

Sub updatelinks()
ActivePresentation.updatelinks

End Sub

When I ran that code, it updated my linked objects with Excel closed.

I hope this helps.

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Thanks! Adrian Microsoft Online Community Support