Maintaining Excel links in Powerpoint when directories change

[Peggy in NJ at ATT]

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.)

 

[Michael Koerner]

You might want to look here for a better solution
Search and Replace for Hyperlinks
http://www.pptfaq.com/FAQ00773.htm

 

[Echo S]

You might try FixLinks. http://www.pptools.com/

 

[Peggy in NJ at ATT]

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.

 

[Michael Koerner]

Glad to hear that you got it sorted out.