Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Word and Excel hyperlinks

Posted on 2012-03-09
7
Medium Priority
?
225 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
0
Comment
Question by:chima
  • 4
  • 3
7 Comments
 
LVL 13

Expert Comment

by:lee555J5
ID: 37703943
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
 

Author Comment

by:chima
ID: 37706180
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
 
LVL 13

Expert Comment

by:lee555J5
ID: 37706195
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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Author Comment

by:chima
ID: 37709374
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
 
LVL 13

Accepted Solution

by:
lee555J5 earned 2000 total points
ID: 37716343
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
 

Author Comment

by:chima
ID: 37721242
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
 

Author Closing Comment

by:chima
ID: 37721898
thanks
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question