» Changing the Source Link

CATEGORY - Links between Worksheet and Workbooks VERSION - All Microsoft Excel Versions

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.
Screenshot // Changing the Source Link