[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Why cant I create a hyperlink from excel to a bookmark in Word?

Posted on 2014-08-16
6
Medium Priority
?
3,185 Views
Last Modified: 2014-08-18
Hello, I seem to not be able to create a hyperlink from excel to a bookmark in word.   Both the word file and the excel file are not shared.  I create bookmarks often in word and link between word docs but this is the first time I have tried to link between excel and word.  I have done a google search and what I found is that if the excel file is shared then hyperlinks dont work but I cant even create a hyperlink.  I thought that maybe the file type could be an issue but i tried both .doc and docx.  

I can create a hyperlink to an excel doc though.

the error i get when trying to create a hyperlink from excel to word is as follows:
"Microsoft could not open this file or could not parse a file of this type"

thank you for the help.  
I am using office 2010.
0
Comment
Question by:pdvsa
  • 4
  • 2
6 Comments
 
LVL 21

Accepted Solution

by:
Eric Fletcher earned 2000 total points
ID: 40265323
This is quite possible— but it is certainly not as intuitive as you would expect from the dialog.

The Excel dialog you used includes a "Bookmark" button, so you would naturally expect that it would allow you to select a bookmark from the chosen document. That will generate the error you received though (and neither the error message nor the associated Help is of much use).

What you need to do is just choose the Word document and then manually add the bookmark after a # symbol.

For example, say you have a bookmark named expCategories within a Word document named Report2013.docx. When you select the Word file name, ignore the "Bookmark" button and just add the # symbol and the Word bookmark name after the Word file name. Click OK.
Creating a link from Excel to a Word bookmarkThe link should work to bring your users directly to the bookmark within the Word document.
0
 

Author Comment

by:pdvsa
ID: 40265583
Odd indeed.  Nice to know it wasn't me or some corruption.  Thank you!
0
 

Author Comment

by:pdvsa
ID: 40266471
Eric,

I have a follow up.  Not sure if you are still montoring.

I have tested the method with the #Enter Bookmark Name  and it does open the file but it doesnt seem to navigate to the bookmark.  

here is an example I hvae tested.  I tested on two files and neither opened to the bookmark.

C:\Users\ToJohnson\Desktop\shortcut.docx#Test

Does this method work on your side?  
I do get this virus warning message box of "Would you like to open this file" and I click yes.  Not sure if that has something to do with it.  

thank you
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:pdvsa
ID: 40266487
below is a screen print
Untitled.jpg
0
 
LVL 21

Expert Comment

by:Eric Fletcher
ID: 40266530
Works fine for me... I don't get a virus warning message, and the link immediately opens to the bookmarked part of the Word file. Excel link to a bookmark within a Word documentPerhaps you should check to see if your virus protection is set to warn you, and see if you can turn it off. (I only have Microsoft Security Essentials running after eliminating all the usual suspects (Norton, MacAffee, etc.) that used far too many resources and nagged for subscriptions. MSE is free; works fine for me -- and doesn't interfere.
0
 

Author Comment

by:pdvsa
ID: 40269295
Ok thank you for the follow up.  I will have to speak with IT as I think it has something to do with Mcaffee virus.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

830 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