Solved

Word and Excel hyperlinks

Posted on 2012-03-09
7
215 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
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 

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 500 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
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…

856 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