Auto update / recalculate Excel links in PowerPoint
Posted on 2009-02-23
I'm using PowerPoint 2007 and I have a link to an Excel Spreadsheet. This sheet "updates" whenever the date changes (calculations based on TODAY() ) . I need code to make the PowerPoint presentation automatically update whenever the date (or in some cases, the time) changes.
How can this be done? So far, I can get it to 'work' with a 'fly-in' transition, if the mouse is appropriately located (so a 'mouseover' macro triggers), but this is an inconsistent workaround. There should be a way to incorporate a VBA 'ActivePresentation.UpdateLinks' command each time a slide reappears. Isn't there?