Hi all,
I've been looking for a solution to this problem for a long time without finding anything that works. Hopefully someone out there can help me in the right direction
I have an excel-file that contains alot of pivot charts and tables that i need to export to a powerpoint presentation (running in fullscreen). The excel files automatically updates itself from a database every 30 seconds. My powerpoint is consisting of two slides, 1 that will show all my data and a second slide that is just a Picture. My understanding is that I can only update a powerpoint slide (while running) if it's not the Active slide being shown, hence the picutre. I downloaded an add-in that will update my links when switching to the other slide but the problem I'm facing is that I get the error message "Application is busy" which sends me to an error window forcing me to pres "ok" or "cancel". Is there a way that I can bypass this error message? I've tried to use some regular methods like application.displayalerts but that didn't work. I dont have a problem if my dashboard isn't updated once in a while (as it is running on a 30 sec update, every couple of minutes would be fine, really) that would be ok but I can't have the application crashing because excel is busy.
I have a couple of different possible solutions but I'm not sure if they could work:
*Check if Excel is busy Before updating the links
*Error handling if Excel is busy
*Timing the files so that Excel updates when Powerpoint isn't trying to update the links (allthough i'm not sure how to get powerpoint to wait as there is no application.wait for powerpoint)
Can any of you recommend how to approach this problem?
Thank you so much in advance!
//Ineona
I've been looking for a solution to this problem for a long time without finding anything that works. Hopefully someone out there can help me in the right direction
I have an excel-file that contains alot of pivot charts and tables that i need to export to a powerpoint presentation (running in fullscreen). The excel files automatically updates itself from a database every 30 seconds. My powerpoint is consisting of two slides, 1 that will show all my data and a second slide that is just a Picture. My understanding is that I can only update a powerpoint slide (while running) if it's not the Active slide being shown, hence the picutre. I downloaded an add-in that will update my links when switching to the other slide but the problem I'm facing is that I get the error message "Application is busy" which sends me to an error window forcing me to pres "ok" or "cancel". Is there a way that I can bypass this error message? I've tried to use some regular methods like application.displayalerts but that didn't work. I dont have a problem if my dashboard isn't updated once in a while (as it is running on a 30 sec update, every couple of minutes would be fine, really) that would be ok but I can't have the application crashing because excel is busy.
I have a couple of different possible solutions but I'm not sure if they could work:
*Check if Excel is busy Before updating the links
*Error handling if Excel is busy
*Timing the files so that Excel updates when Powerpoint isn't trying to update the links (allthough i'm not sure how to get powerpoint to wait as there is no application.wait for powerpoint)
Can any of you recommend how to approach this problem?
Thank you so much in advance!
//Ineona
