View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lar lar is offline
external usenet poster
 
Posts: 1
Default update links when copying files

I have a budget folder with several workbooks containing
links. I made of copy of the folder, however the links in
the workbooks in the copied folder and still pointing to
the original folder. Is there anyway to automatically
update the links with the new path without having to go
to "edit, link, change source" for each workbook?

Any help and/or advice is greatly appreciated.