Dynamic links from Web pages.............

[romeo]

I have a link from my web page to a specific cell in an excel spreadsheet. Whenever I insert a line above the link in the spreadsheet, the "active" cell doesn't move downward with the text that I was trying to link to. In other words, the text moves down one line and the active cell stays in place. Is there a way to make the active cell "link" move with the text when inserting a line above it in the spreadsheet?

 

[s-o-s]

On 2002-09-17 13:42, romeo wrote:
I have a link from my web page to a specific cell in an excel spreadsheet. Whenever I insert a line above the link in the spreadsheet, the "active" cell doesn't move downward with the text that I was trying to link to. In other words, the text moves down one line and the active cell stays in place. Is there a way to make the active cell "link" move with the text when inserting a line above it in the spreadsheet?

First name the cell

Insert | Name | Define
eg My Link in Cell H10

Next Insert Hyperlink
In the Buttons on the left select "Place in this document"
In the "Defined Names" Section select the name you have just created.

OK

As you insert lines the link will remain dynamic.

 

[romeo]

Thankyou for your help.