If you open the file with the link to the original file, then the formulas that
point back will adjust.

If you don't have too many links, maybe you can name the cells that get
retrieved. In xl2003 menus, it's Insert|Name|Define.

Then point at that name in your formula.

Jen wrote:

Ordinary links work like a window, looking in at another workbook. The link
is to the cell regardless of what is in it. Adding rows or columns in the
source file which shifts the data around effectively breaks the link because
even though the link is still looking at cell B3, the relevant data is now in
cell B5. Is there a way to link to the value of the cell so the link would
update itself if the linked data gets moved?

--

Dave Peterson