Tip Printed from ExcelTip.com

---

Changing the Source Link


Changing the source link allows changing the address of the source workbook on the hard disk, or to exchange one workbook for another.

To change the source link:

1. From the Edit menu, select Links.
2. Select the source workbook you want to change, and then click Change Source.
3. Select the workbook that should be linked in the folder you have opened, and then click OK.