I have a continuously looping powerpoint presentation that links to objects in Excel. Sometimes, a conflict occurs when Powerpoint tries to access the Excel file and I get the error message "The Source Application is Busy and Can't Respond Immediately". This error box halts the slide show until I manually select one of two options, "Retry" or "Cancel". Since this seems to be because Excel hasn't finished the process of updating data queries, hitting retry resumes the slide show.

Is there any way to automate a repsonse of "Retry" when this error box comes up? Maybe it could be accomplished by SendKeys during the slideshow? Using a combination SendKeys 'Enter' and OnTime could potentially work. In that scenario I would set Enter to happen as frequently as I want the slides to change (ten seconds), and then if the error box popped up Enter would automatically cause the show to resume.

Thoughts? I'd really appreciate some help here.