External workbook links don't update when source file changes

[Lori Lynn]

HELP! I have a workbook containing links to a worksheet in another workbook.
The source file contains various totals that change each day as I add rows
with additional numbers. Every time I revise the source file, and the cells
containing the totals move to different locations, the values in my
destination file turn to 0. The links in the destination file do not see the
totals in their "new addresses" - and I have to manually create new links
each time. I assume this has to do with absolute vs. relative but nothing I
try is working! HELP!

 

[Gary''s Student]

If all else fails, assign a Named Range to the link points. They will track
the correct cells even if you add/remove rows/columns:

something like:
='E:\Book2.xls'!alpha
instead of:
='E:\[Book2.xls]Sheet1'!$A$2
or
='E:\[Book2.xls]Sheet1'!A2