Solved Copying a group of files with links between them every month

September 26, 2012 at 15:14:47
Specs: Windows 7

I have about 60 excel files linked to a summary which are saved in a single folder. I want to copy the whole folder to a new folder each month with the summary in that particular folder linking to the files in the same new folder. My problem is, when I copy the whole thing, the summary still relates to the old files in the previous folder.

Can we group these files so that when they are copied to a new folder, the links can be moved along with the files to the new folder location??

See More: Copying a group of files with links between them every month

Report •

September 26, 2012 at 17:21:18
✔ Best Answer
Tell me what I'm doing differently than you...

I created 2 workbooks:


In [Book2.xlsx]Sheet1!$A$1 I put =[Book1.xlsx]Sheet1!$A$1

I created a folder called Test and saved both files to that folder. If I open just Book2, [Book2.xlsx]Sheet1!A1 contains:

='C:\Documents and Settings\DerbyDad03\Desktop\Test\[Book1.xlsx]Sheet1'!$A$1

Note that it is looking at the Test folder, as expected.

Then with Excel closed, I created a folder called Test 2 and copied both files into it. I then opened Book2.xlsx form the Test 2 folder.

[Book2.xlsx]Sheet1!A1 contains:

='C:\Documents and Settings\DerbyDad03\Desktop\Test 2\[Book1.xlsx]Sheet1'!$A$1

which means that it updated the link to follow where Book1.xlsx was copied to.

Do you not see that same thing when you copy the files to the new folder?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

September 26, 2012 at 17:52:05

Thank you for that. I copied all my set of files to the hard Drive into a new folder as you said and they came with links to the new file location. Looks like it is working automatically.

Yesterday when I copied within the server, it did not work due to some reason. May be due to a long file path. I will, from now on make a first copy to the local drive and then copy to the server into the new folder to be certain as when it is copied to the local drive, path is short and easy to check.

Kind Regards,


Report •

Related Solutions

Ask Question