Updating powerpoint player
I'm new to this and basically what I want to do is: -I have 2 excel files and 1 powerpoint presentation -all of the files are in a shared network -I linked my excel files to the powerpoint -I have office 20 versions The problem: I play the slideshow of the powerpoint and set it to loop on 1 computer to display it on a big LCD at work, I then access the excel files on a separate computer and update it from there, the problem is the slideshow that is playing wont display my changes automatically.
I have found a somewhat similar question here but it was not answered to the point where it will help me advance my question.
If your question isn't answered here, post it on Microsoft Answers: The Power Point Support Forum (and the former Power Point newsgroup, etc.) Thanks to everyone on the newsgroups for asking such interesting and challenging questions, and a very special thanks to the Power Point MVPs and the Oughta Be MVPs who've contributed so much to this site and to the larger Power Point community.
Now there are some that still dont have solutions for this problem, hope this helps you. I installed the Auto included in the zip as an Add In and activated it in PPT2007 and PPT2003.
and then created a normal module/macro with this code. Update Links End Sub Sub On Slide Show Page Change(By Val SSW As Slide Show Window) ' ' AUTO UPDATE OF OLE LINKS MACRO ' If SSW. Current Show Position = 2 Then Active Presentation. Please make sure that you save your powerpoint in macro-enabled format both for 20, this is because I have two versions of ms office.
and tick the ckeck box saying -Trust access to the VBA project object model. Public With Events PPTEvent As Application Sub PPTEvent_Slide Show Next Slide(By Val Wn As Slide Show Window) Dim obj Sld As Slide, shp As Shape Set obj Sld = Wn. Also loop your slideshow so that when it passed the slide 2 or just the beginning of the show, it will update all OLE links.