Hi
I'd guess you use the function 'Insert - Hyperlink' for your link. If you
could provide some more details what you exactly try to link there may be an
option to use the hYPERLINK formula instead.
Provide some example data for your linked sheet

"Samad" wrote:

Thanks Frank, but the problem is when I insert row I have to change all
hyperlink of the worksheet, can you suggest another way to link.


"Frank Kabel" wrote:

Hi
the HYPERLINK always refers the cell position but not the content of this
cell. So you can't do it this way

"Samad" wrote:

When I Hyperlink cells to another sheet's cell and when I move data to other
row/ column or I insert rows/column it does not move hyperlinked address.

Can anyone advice me how to move hyperlink address with insert/move
rows/column/cells.
Thanks