 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / February 2007Maintaining Excel links in Powerpoint when directories change
I have a Powerpoint 2003 file that that dozens of links to charts and named ranges in 2 or 3 Excel 2003 files. All the files are in the same directory. I need to copy all of the files into a new directory. I was anticipating that the links would be "relative" and would automatically be able to be updated. It looks like I have to manually change the link for each linked object. Isn't there an easier way? (In earlier versions of powerpoint/excel I don't think I had this issue.) You might want to look here for a better solution Search and Replace for Hyperlinks http://www.pptfaq.com/FAQ00773.htm  SignatureMichael Koerner MS MVP - PowerPoint >I have a Powerpoint 2003 file that that dozens of links to charts and named > ranges in 2 or 3 Excel 2003 files. All the files are in the same [quoted text clipped - 5 lines] > powerpoint/excel > I don't think I had this issue.) inThanks for the referral. This is just what I needed for my OLE objects. I did have to fix the code since the references to "oSh" were not correct in all places in the OLE routine. > You might want to look here for a better solution > Search and Replace for Hyperlinks [quoted text clipped - 9 lines] > > powerpoint/excel > > I don't think I had this issue.) Glad to hear that you got it sorted out. SignatureMichael Koerner MS MVP - PowerPoint > inThanks for the referral. > [quoted text clipped - 19 lines] >> > powerpoint/excel >> > I don't think I had this issue.) > inThanks for the referral. > > This is just what I needed for my OLE objects. I did have to fix the code > since the references to "oSh" were not correct in all places in the OLE > routine. Let me know what problems you needed to fix ... may as well get it fixed in the code on the site as well. Thanks! > > You might want to look here for a better solution > > Search and Replace for Hyperlinks [quoted text clipped - 9 lines] > > > powerpoint/excel > > > I don't think I had this issue.) ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ You might try FixLinks. http://www.pptools.com/ SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2007? http://www.echosvoice.com/2007.htm Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/ >I have a Powerpoint 2003 file that that dozens of links to charts and named > ranges in 2 or 3 Excel 2003 files. All the files are in the same [quoted text clipped - 5 lines] > powerpoint/excel > I don't think I had this issue.) > I have a Powerpoint 2003 file that that dozens of links to charts and named > ranges in 2 or 3 Excel 2003 files. All the files are in the same directory. > I need to copy all of the files into a new directory. I was anticipating > that the links would be "relative" and would automatically be able to be > updated. Not exactly. Links to Excel and other such "server" apps are always hard-coded/fully pathed. As long as the original file is available in its original location, PPT will find and use it. But if file's not available where the path points, PPT will look in the current directory for it. In most cases, the current directory is the one where the PPT file itself is. If all the needed XLS files are in the same folder as the PPT, try this: - Make a backup copy of the files from their original location; put it on CD or other removable media, then delete the originals - Start PPT and choose File, Open to open the file from its new location or - Doubleclick the PPT file in its new location but - DO NOT start PPT then choose File and click one of the numbered files at the bottom of the file menu. That should work. If not, choose File, Properties and verify that the file's Hyperlink Base setting is blank. >It looks like I have to manually change the link for each linked > object. Isn't there an easier way? (In earlier versions of powerpoint/excel > I don't think I had this issue.) ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.