We help IT Professionals succeed at work.

Word and Excel hyperlinks

Medium Priority
249 Views
Last Modified: 2012-06-22
Hello,
I am back.  The hhyperlink between Word and Excel is not working as I am hoping it will work.
The file attached explains what I need.  The screenshot is just half of the problem;
Ssscreenshot
Please see the attached file.
Word-to-Excel-hyperlink.doc
Comment
Watch Question

Commented:
Are you saying you want it to always point to A5? If so, you can lock it to A5 by changing the reference from relative to absolute with "$". For example,

$A$5 locks the column and the row
$A5 locks the column but the row is still relative
A$5 locks the row but the column is still relative

Is this what you're looking for?

Lee

Author

Commented:
lee555J5 what you are say is correct, and I seen this work within excel itself.
What I need is that when I set up the hyperlink and add rows before that hyperlink.
When I go back to the Word Doc and click on A8 hyperlink (In the excel sheet after adding to rows is at A10).  The A8 hyerlink must now follow the changes and point to A10 (not A8, the old cell location.)

I have excel 2003 11.8, I am thinking that this does not work in this version of excel.

Commented:
I don't know of a way for Word to know A8 is now A10 in Excel by cell notation only. Try naming your cell for hyper-linking as a named range. The named range moves with row insertions and deletions. This way, Word can hit the moving target. I'm sorry it's been too long, so I don't remember how to name a range in Excel2003.

Author

Commented:
lee555j5, I looked into "name a range" and do not think this will work, but I will look at it again.  I found a couple of links on line about "name a range" and did not really understand how to set it up, but I will read some more.
Commented:
Did you get it working?

See this site for naming ranges in Excel 2003.
http://www.uwec.edu/help/excel03/rgnme.htm

The easiest way should be to highlight the cell to name and type the desired name in the name box (the box near the top left with the column/row in it, such as A1).

Author

Commented:
lee55j5, gee I had my doubts, but it works; now I can insert rows and the set hyperlink remains connected to the row/cell previously set.
thanks

Author

Commented:
thanks

Explore More ContentExplore courses, solutions, and other research materials related to this topic.