View Single Post
 
Old 08-03-2011, 06:27 AM
strebewi strebewi is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Aug 2011
Posts: 1
strebewi is on a distinguished road
Question automate selection of new source for linked objects

I have a Powerpoint Presentation that is linked to one large Excel file. There are approximately 60 links within the presentation. The presentation is distributed to a number of users along with the Excel file. The individuals update the Excel information for their customers and then they update the links in the Powerpoint. The issue is that the users do not save the documents in the same path as the original file or with the same name (despite receiving instructions). I would like to find a way to automate the presentation to have a dialogue box pop-up that would instruct them to select the source file and have all 60 links automatically use the new source Excel file. Any thoughts, suggestions, or solutions?
Reply With Quote