Log in

View Full Version : How do I auto update data on slide



Kicker
01-30-2010, 11:09 AM
I have a presentation that is manually updated with data from several different Excel and Access files. Is there anyway to link the Slide data to automatically update when the slideshow (.pps file) is opened?

mike31z
02-11-2010, 09:21 AM
Here a link to how I solved my same problem 2 years ago.

http://skp.mvps.org/updtlinks.htm

Inorder to speed up the update process during the slide show loop. I created a source spreadsheet in the same folder with the powerpoint file. I also automated the refresh in the spreadsheet to update the hyperlinks to other spreadsheets.

If other are going to update information that is to be displayed. They have to learn to save the data on the source file before it can be updated in the slide show.

The more links you have the longer it takes to update during each loop. If instal the updatelink above just uncheck the box to stop the show. Its one of the options in the user interface.


Mike in wisconsin

Kicker
02-11-2010, 05:17 PM
MIke
Thank you very much. This looks like what I am searching for.