Ok say I have an Excel sheet that gives me all my data and each section in that Excel sheet is linked (embeded object) to a PPT slide. How do I get the data in the powerpoint slides to update based on data (primary key) rather than cell position? For example (see excel data source table below): If I have a slide that has an embeded Excel object that is named and for Unit AAA along with its data and another one for BBB and so on for CCC. This structure works great until next months Excel output that has AAA, GGG, BBB, CCC. Now the slide that has unit BBB is actually showing the data for GGG and all those that follow are messed up as well. Is there any way to update powerpoint slides based on data, not position, of an Excel data source? Thnx in Advance
DATA SOURCE FOR 1st MONTH:
AAA data data data ------------------ ------------------ BBB data data data ------------------ ------------------ CCC data data data
DATA SOURCE FOR 2nd MONTH
AAA data data data ------------------ ------------------ GGG data data data ------------------ ------------------ BBB data data data ------------------ ------------------ CCC data data data
Bookmarks