Hello all,
I have the exact same Problem as someone in an pretty old thread ( How to close modal windows automatically? )
I am pretty desperate, I spent hours today trying to find a fix.. Can anyone maybe help me? I would even be open for any sort of workaround or hack.
QUOTE:
I dashboard a continuously running PowerPoint presentation that feeds off of data and charts from Excel. From time to time (between once to a handful of times a day) I get the error message in PowerPoint: "The Source Application is Busy and Can't Respond Immediately."
Via Microsoft, You Cannot Stop or Cancel the "The Source Application Is Busy and Can't Respond Immediately" Error Message, it's because a modal window is open in Excel. However, every time I receive this error, I go to Excel and I don't see a modal window, so the error appears to have taken care of itself in Excel immediately. However, PowerPoint won't continue until I hit retry (which always works).
Is there any way I can automatically close out of a modal window? At this point, I can only hypothesize what might be causing the error because the error window never shows in Excel by the time I get there. I'm thinking it's either:
Do you guys think the problem is fixable in Excel or is it a PowerPoint issue? Is there any way to at least automatically close out the unsuccessful web query error box?
I have the exact same Problem as someone in an pretty old thread ( How to close modal windows automatically? )
I am pretty desperate, I spent hours today trying to find a fix.. Can anyone maybe help me? I would even be open for any sort of workaround or hack.
QUOTE:
I dashboard a continuously running PowerPoint presentation that feeds off of data and charts from Excel. From time to time (between once to a handful of times a day) I get the error message in PowerPoint: "The Source Application is Busy and Can't Respond Immediately."
Via Microsoft, You Cannot Stop or Cancel the "The Source Application Is Busy and Can't Respond Immediately" Error Message, it's because a modal window is open in Excel. However, every time I receive this error, I go to Excel and I don't see a modal window, so the error appears to have taken care of itself in Excel immediately. However, PowerPoint won't continue until I hit retry (which always works).
Is there any way I can automatically close out of a modal window? At this point, I can only hypothesize what might be causing the error because the error window never shows in Excel by the time I get there. I'm thinking it's either:
- Using the ontime() function, I automatically refresh the pivot caches and charts every ten minutes. This may conflict with a PowerPoint add-on that refreshes the links to the Excel objects every time the slideshow loops. The presentation hangs for a few seconds every time the linked data changes, and I'm wondering if PowerPoint is unable to read the link data if it is being refreshed in Excel. I always receive this error on the first slide (when it refreshes the linked data) so I'm thinking the likely culprit is in here.
- I have data connections in Excel that use web queries to google drive, sometimes I get an error message in Excel that says the data refresh was unsuccessful, but this doesn't appear to have any affect on the PowerPoint presentation.
Do you guys think the problem is fixable in Excel or is it a PowerPoint issue? Is there any way to at least automatically close out the unsuccessful web query error box?