Hi All,

Firstly, apologies, I posted this in the Powerpoint section; very few peaople seem to reply to threads in there and, as this is about VBA, I felt I could post here. It is duplicated so one of the moderators may want to delete (hopefully!) the other version.

I have a number of presentations that link to the same workbook in Excel.
For simplicity, let's assume there are only two, Show A & Show B.
The links are predominantly graphs, the slideshows run at the same time on loop and all graphs are set to auto update.

I have the below code in each presentation, kindly supplied by Jaslake:-


Please Login or Register  to view this content.
The issue I have is that only the presentation that has focus upates. i.e. if Show A is selected, Show B will not update.
The salient part of the code is ActivePresentation.Updatelinks. Is there a command that will say AllPresentation.Updatelinks or, can I pass focus onto the next presentation and perform the update, next presentation active, or something along those lines?

This is driving me nuts! I've been trying to get a solution on the internet for days.

Thanks for any help you can give, Feastie.