Updating Powerpoint Dashboard from Excel

ineona

New Member
Joined
Jun 21, 2016
Messages
5
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
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,223,054
Messages
6,169,834
Members
452,284
Latest member
TKM623

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top