Word and Excel hyperlinks

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
chimaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
lee555J5Connect With a Mentor 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).
0
 
lee555J5Commented:
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
0
 
chimaAuthor 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.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
lee555J5Commented:
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.
0
 
chimaAuthor 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.
0
 
chimaAuthor 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
0
 
chimaAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.