Links - Copy a Workbook to another Directory
 

Good Afternoon,
I have inherited a file that has a number of links to other files. Each
month the file is copied and a new version is pasted in a new folder (ie.
C:/July/July File.xls, C:/August/August File.xls) The file has links that
refer to another file in the old folder that need to remain but when the file
is copied it changes the link from C:/July/July LinkedFile.xls to
C:/August/July LinkedFile.xls. Is there any way to avoid this from happening?
Any help would be greatly appreciated.
--
Thank You,
Steve