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.



Leave a Reply

Your email address will not be published. Required fields are marked *


6 + = fourteen

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>