Automatic data updates

[S Shipley]

I searched the posts and didn't find anything that matched what I am trying
to do so here goes:

I have a deck of about 160 slides with each having a common header and a
body that has common data elements.

In the header there are two pieces of information; an ID number and a Global
ID number. Both of these numbers are stored in an Excel spreadsheet.

I want to automatically populate the Global ID number by doing a lookup on
the ID number from the PP header and then finding the corresponding Global ID
number in the Excell Spreadsheet.

In the body of the PP slide there is a table that has several data elements.
I would like to update these data elements by using the ID number in the
header to do a lookup in the Excel spreadsheet to find the row and the cells
that have the data.

I only need to update the data when I open the PP presentation - it doesn't
need to be able to update during a slide show.

Thanks in advance for the help,
S Shipley

 

[David M. Marcovitz]

I wonder if PPTMerge will do what you want:

http://www.rdpslides.com/pptools/merge/FAQ00011.htm

--David

--
David M. Marcovitz
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/

 

[S Shipley]

Thanks David I will give this a try. The only problem I see is that there
are about 40 people who need this functionality and getting this tool for
them is extremely difficult at best and nearly impossible as the most likely
outcome. This tool is being used at one of the Big 3 auto companies so red
tape is the order of the day.