» Changing the Source Link in Excel 2007
Changing the source link allows changing the location of the source workbook on the hard disk, or to exchange one workbook for another.
To change the source link:
1. Select Data -> Edit Links to Files (in Manage Connections Group).
2. In Edit Links dialog box select the source workbook you want to change, and click Change Source.
3. Select the workbook that should be linked in the folder you have opened, and click OK.