dependency changes after row insert

[John]

I have a collection of worksheets that I set up, where entries for one sheet
are updated from another worksheet. In order to ensure that I can re-track
data entries and amounts, I have placed hyperlinks to an off-print section of
each worksheet so that I can quickly page from one spot of a worksheet to
another. By entering an exact cell referencing, when I page to a sheet using
the link, the resulant sheet has the targeted cell outlined. So far, so good,
and things are working well. However:

I'm wondering what happens when one inserts a row anywhere in a sheet, if
that disrupts the hyperlinking. I.e., is there anthing that a person needs to
do to ensure that the linkage reflects correct cell addressing?

 

[RichardSchollar]

Hi John

So you are concerned that say a link that points to A1 will still
point to A1 even after a row has been inserted above he existing row1
- and you would prefer that the link now points at 2?

I would create your links differently - just use a straightforward
formula such as:

=A1

instead of creating a hyperlink. If (in xl2003 and below) you go
Tools>Options>Edit tab and uncheck "Edit directly in cell" and then
click OK, now back in the sheet, double-clicking on this formula cell
will take you directly to the referenced cell. If a row is inserted,
the formula will automatically be updated and so will take you to A2
etc.

Hope this helps!

Richard