Maintaining Excel links in Powerpoint when directories change

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.)
 
Peggy in NJ at said:
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.
Click to expand...

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.
 
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.
 
Peggy in NJ at said:
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.
Click to expand...

Let me know what problems you needed to fix ... may as well get it fixed in the
code on the site as well.

Thanks!
 
Back
Top