Reply to thread

Message: [QUOTE="mikearelli, post: 11487038"] I've read through almost all 300,000 posts regarding linking Excel charts into PowerPoint presentations with no success finding an answer to my dilema without spending a lot of money to buy someone elses add-in that still may not work as I would like. I intend to run a slide presentation in a continuous loop. For testing purposes, I've created an Excel 2007 table and created 3 charts from that table. Each chart is pasted as a link onto it's own slide in a 3 page PowerPoint 2007 presentation. While the presentation is running, I want to be able to update the Excel data at will, then, once saved, have the changed data show in the PowerPoint slide show. There is an add-in that is almost ALWAYS refered to that is supposed to update all the links within a presentation. I've downloaded and installed that add-in, but when I run it, it claims I don't have any linked objects in my presentation. I'm assuming this is because I'm in a newer version of PowerPoint than this add-in was designed for. When I save and close, then reopen this PowerPoint presentation, I do not get the updated charts like I expect. I still have to double click each chart before the chart displays the updated data. Did I just create the links improperly? When I am in Excel, I right-click on the chart and select copy. In PowerPoint, I right-click on a slide and select paste. I do not get a Paste-Special option. I'm also assuming that's because I'm in a newer version of PowerPoint. I'm looking for help in recreating the actions of double clicking on the chart to obtain the most current data through code. My best guess was the code: Sub OnSlideShowPageChange() If ActivePresentation.SlideShowWindow.View.CurrentShowPosition = 1 Then 'This is the first slide, let's update the links ActivePresentation.UpdateLinks End If End Sub This code successfully determines I am on the first slide, but the UpdateLinks does nothing. Any suggestions? [/QUOTE]

Verification