Solved

Word and Excel hyperlinks

Posted on 2012-03-09
7
211 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now