Macro link to Excel in Powerpoint

[olimajor123]

Hi there,
I am looking to have a powerpoint presentation duplicate information on an excel spreadsheet. I basically have a 12 team fantasy football draft and I want a powerpoint presentation to cycle through 12 slides (1 per team) and automatically update as I update the teams on my excel workbook. I believe I will need a macro in Powerpoint where it auto updates the links to excel every 30 seconds or so.

Can you please advise how I would do this?

Thanks

 

[Worf]

Hi

Insert the range object in PowerPoint by following these steps:

1) Select the range and copy it.
2) At PowerPoint, click paste special.
3) At the dialog box, click paste link/object/OK.

With Office 2013, changes I make in Excel are immediately reflected on the corresponding slide.
Note that link updating can be automatic or manual. The macro below could also be used; it can be scheduled to run every minute or so.

' PowerPoint macro
Sub linkupdate()
Dim sld As Slide, shp As Shape
On Error Resume Next
For Each sld In ActivePresentation.Slides
    For Each shp In sld.Shapes
        shp.LinkFormat.Update
    Next
Next
On Error GoTo 0
End Sub

 

[olimajor123]

Hi

Insert the range object in PowerPoint by following these steps:

1) Select the range and copy it.
2) At PowerPoint, click paste special.
3) At the dialog box, click paste link/object/OK.

With Office 2013, changes I make in Excel are immediately reflected on the corresponding slide.
Note that link updating can be automatic or manual. The macro below could also be used; it can be scheduled to run every minute or so.

' PowerPoint macro
Sub linkupdate()
Dim sld As Slide, shp As Shape
On Error Resume Next
For Each sld In ActivePresentation.Slides
    For Each shp In sld.Shapes
        shp.LinkFormat.Update
    Next
Next
On Error GoTo 0
End Sub

Hi,

The pasting of the links seems to work well as it auto updates as I update the excel sheet.

I plan to have the laptop plugged into a tv and to split the screen and have the excel sheet on my laptop and the powerpoint on the TV screen. My question would be that if I set the powerpoint to cycle the slideshow constantly on the tv, would the slide show update with the links or would I need the Macro for that?

 

[Worf]

You should test it with your hardware and software setup to see if it updates automatically.
In case it does not, we can have code to force the update every time a certain slide is shown, as the on time method does not exist in PowerPoint.

 

[Worf]

This is how you can use PowerPoint events to fire a macro every time a slide is shown.
Firstly, run the initialize routine, and then start the slide show.

' standard module
Dim X As New Class1
Sub InitializeApp()
    Set X.App = Application
End Sub

' class module named Class1
Public WithEvents App As Application


Private Sub App_SlideShowNextSlide(ByVal Wn As SlideShowWindow)


If Wn.View.CurrentShowPosition = 2 Then LinkUpdate


End Sub