Links - Copy a Workbook to another Directory

S

Steve D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top