Link does not automatically update

[Guest]

I have some graphs linked to several excel files.
I have found that if I change the file name of those excel files, I cannot
automatically update these graphs. And I have to do change sources for each
graphs.

I wonder if there is a quicker way to update these links, such as writing
some macro coding.

 

[Steve Rindsberg]

I have some graphs linked to several excel files.
I have found that if I change the file name of those excel files, I cannot
automatically update these graphs.

Right. The link is little more than a pointer to "The file named XXX stored in
C:\Some\Folder\"

If you move the file or change the name, the file, as described in the link, no
longer exists.

I wonder if there is a quicker way to update these links, such as writing
some macro coding.

If the name changes are consistent, then yes, it's fairly simple.

Search & Replace to change OLE link paths
http://www.rdpslides.com/pptfaq/FAQ00759.htm

 

[Guest]

Dear Mr Rindsberg

Thanks a million for your time and expert advice

I find the code very useful. I do see the code running smoothly, but when I
go back to the powpoerpoint, the slides were not updated.

Hope you would not mind to advice further
Jaylin
*****Jaylin Message ended*******

 

[Steve Rindsberg]

Dear Mr Rindsberg

Thanks a million for your time and expert advice

I find the code very useful. I do see the code running smoothly, but when I
go back to the powpoerpoint, the slides were not updated.

In order for it to work, you must have a copy of the linked file in the folder
you're trying to re-link to. If you change the link to point to a file that's not
there, PowerPoint just nods, smiles and ignores you.

 

[Steve Rindsberg]

Dear Mr Rindsberg

Thanks a million for your time and expert advice

I find the code very useful. I do see the code running smoothly, but when I
go back to the powpoerpoint, the slides were not updated.

Hope you would not mind to advice further

Have another go with the slightly modified version posted at the same link.

 

[Guest]

Dear Mr Rindsbert

Thanks a million for your time and expert advice The code really helps
Jaylin
*****Jaylin Message ended*******

 

[Steve Rindsberg]

Dear Mr Rindsbert

Thanks a million for your time and expert advice The code really helps

Great ... what turned out to be the magic to make it work?