You must mean a link to a sheet in another workbook. If both cells are within
the same workbook you shouldn't have this problem.

Assign a range name to the cell in the source workbook, then recreate the
link from the other workbook. Excel will find the named cell in the source
workbook even if its row and/or column has changed.

Hope this helps,

Hutch

"ickleyates" wrote:

Hi,

I have set up a link to a cell in a worksheet, but when I make alterations
to the worksheet e.g. delete a column the hyperlink remains with the cell not
the contents, as if e.g. $A$1. Is there a way to avoid this?

Many Thanks,

J.