How can I get Excel to automatically change file path links?

[Guest]

I am trying to create an identical folder to one I already use. The catch is
that all of the linked worksheets in this new 'copied' folder must recoginze
the new folder name, not the old. I assume that excel can do this but
everything I have tried so far doesn't work.

This is what I want done:
The folder c:\FY2006 is copied so that there is a c:\FY2007. I have
multiple worksheets within 'FY2006' that are linked to other worksheets,
within 'FY2006', that I would like to automatically become linked within
'FY2007.' Every attempt I have done so far copies all of the workbooks to
FY2007, but the links for each workbook still have the file path of FY2006.

 

[Ragdyer]

From FY2007, click on:
<Edit> <Links> <Change Source>

And navigate to FY2007 in the window, and link it to itself.