Update Links to Excel

[Jeffack]

Hi,

I'm creating a PowerPoint presentation which contains many charts. All of the charts are based off data in one Excel file. So, for each chart, I created the chart in Powerpoint and, when it took me to this Excel worksheet which it embedded in the presentation to populate the chart, I simply linked each cell to the appropriate cell in my original Excel file.

I'm finding a problem with this, however: If I change my original Excel file, the changes do not automatically populate in my chart. In order for them to populate, I have to right-click on the chart and click "edit data". When I do that, the embedded Excel file opens, the linked data refreshes, and my chart is updated.

I have approximately 50 slides in this presentation, and it needs to be updated frequently, so I'm looking for some way (probably a macro) to expedite this.

Thanks in advance for your help!

[Paul_Hossler]

1. Use a macro


Sub UpdateCharts()
ActivePresentation.updatelinks
End Sub


2. You can add 'Update Links' to the QAT in 2007/2010

Paul

[Jeffack]

Hi Paul,

Thanks for the help. Unfortunately, for whatever reason, when the links are inside the .xls file that is created when I added the chart, PowerPoint doesn't realize that they're links; they don't show up when you go to "edit links" and the .updatelinks VB command doesn't work. I've attached a powerpoint which contains one of these charts.

Thanks,
Jeff

[Jeffack]

An example file is attached.

[Paul_Hossler]

Jeff

Sorry, I've always kept the data and charts in Excel and just pasted the charts into PP

If I embedded Excel Charts, then they each get their own data sheet, and then I get confused

Paul