Maintaining Excel links in Powerpoint when directories change

[Guest]

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/

 

[Steve Rindsberg]

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.

 

[Guest]

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.

 

[Steve Rindsberg]

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!