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

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.
pdvsaProject financeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Eric FletcherCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pdvsaProject financeAuthor Commented:
Odd indeed.  Nice to know it wasn't me or some corruption.  Thank you!
0
pdvsaProject financeAuthor Commented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

pdvsaProject financeAuthor Commented:
below is a screen print
Untitled.jpg
0
Eric FletcherCommented:
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
pdvsaProject financeAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.