KB149660 - External Link Not Updated When Source Cell Moved

RESOLUTION

To make sure your linking formulas update correctly when the source workbook changes, do either of the following:

Make sure the dependent workbook (with the linking formulas) is open when you make changes to the source workbook. -or-
Use defined names in the source workbook and change your linking formulas so they refer to these defined names and not cell references.

For example, if your linking formula is currently:
```
    Microsoft Windows
    -----------------

      ='C:\Directory\[Source.xls]Sheet1'!$A$5

    Macintosh
    ---------

      ='hd:direcory:[Source]Sheet1'!$A$5
						
```
then you would want to give cell A5 in the source workbook a defined name. For this example, you can define cell A5 in the source workbook as mycell. If this is done, you would want to change your linking formula to:
```
    Microsoft Windows
    -----------------

      ='C:\Directory\Source.xls'!Mycell

    Macintosh
    ---------

      ='hd:direcory:source'!mycell
```

MORE INFORMATION

Select a cell or a range of cells.

On the Insert Menu point to Name and then click Define.

In the Define Name dialog box, type a name for the cell or range, and then click OK.

Go to the linked workbook and select the cell with the link.

In the formula bar, drag the mouse to select the cell reference, including the '$' signs. For example $A$5.

Type the defined name that corresponds to that cell, and then press ENTER.