Microsoft Excel Tips
and Tricks
Keep Links to Source Workbooks Up-to-Date
One of the great things about Excel is that you can create
formulas in one workbook that link to data stored in another
(source) workbook. But, when your source workbook changes
regularly (for example, if you update the source and save it
under a new name each month), it can be very time-consuming
to find and update links to the old source workbook.
Fortunately, there's an easy way to do this:
1.
Open the workbook that contains the link(s) .
2.
On the Edit menu, click Links.
3.
In the Source box, click the name of the link with
the source you would like to change.
4.
Click Change Source.
5.
In the Change Source dialog box, click the source
workbook you want to refer to.
Editor's Note:
To successfully change source workbooks, the linked data
must reside in the same cells (for example, A15, D24) in the
new source workbook as they did in the old.
|