Two-way or hot links

The easiest way to create a two-way link is to type it directly. For example, if A1 contains 123, type the formula

! A1

in any other cell, say E10. The contents of E10 will always be the same as A1 and you can edit data at either end of the link. For example, entering 456 in E10 or A1 will cause both E10 and A1 to display the same result - 456.

As an alternative, you can use a paste special operation to achieve the same result. For example:

  1. Click in cell A1

  2. Select Copy by right-clicking your mouse

  3. Click in cell E10, which is to contain the linking expression

  4. Select Paste Special by right-clicking your mouse

  5. Select Paste Hot Link from the "Paste Special" dialog

To convert a one-way link into a two-way link, select the Edit Source button image\editsrc.gif or select the Attributes command from the Format menu, and then check Edit Formula Source. Selecting the Edit Source button again will convert the two-way link back into a one-way link.

See also:

Two-way links between documents

One-way links