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

Posted on 2014-08-16
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.
Question by:pdvsa
    LVL 21

    Accepted Solution

    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.

    Author Comment

    Odd indeed.  Nice to know it wasn't me or some corruption.  Thank you!

    Author Comment


    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.


    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

    Author Comment

    below is a screen print
    LVL 21

    Expert Comment

    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.

    Author Comment

    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.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    734 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

    16 Experts available now in Live!

    Get 1:1 Help Now