Powerpoint 2010 - Auto pdate embedded Excel 2010 worksheet

[ktoon]

Hi,

Not sure if Powerpoint VBA is the same as in Excel so please just close this thread if I'm in the wrong.

Essentially I have inserted a linked worksheet object in to a Powerpoint slide and I would like this worksheet to automatically update each time this particular slide is viewed. The goal is to be able to view it on a TV with no user interaction then another department can update the Excel file separately.

Currently I have the Edit links set to manual refresh otherwise with automatic there is a pop-up on startup to accept the automatic update links setting.

This is what I found online not sure how far wrong it is (it doesn't work either way...)

Sub refresh()    If SSW.View.CurrentShowPosition = 1 Then
        ActivePresentation.UpdateLinks


End Sub

Any help would be much appreciated, I have been researching this for hours!