Link does not automatically update

[Jaylin]

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.

 

[Jaylin]

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*******

 

[Jaylin]

Dear Mr Rindsbert

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