Yet another linked Excel chart question


M

mikearelli

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?
 
Ad

Advertisements

M

mikearelli

Nevermind. I was pasting wrong. That made all the difference.
Instead of right-clicking and selecting paste, I went to the ribbon and
clicked the down arrow under Paste. There I was able to select
Paste-Special, then paste as a link.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top