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