Today i was given the task to link some cells from an excel document to a set of headings in a word file. It was a bit time consuming however I found out how it was done.

Just follow the steps below.

Things you need to know:-

  1. Make sure both the files are in the same location.
  2. If the word file is renamed after the links are made, you will get an error and remake all the links.
  3. The excel file can be renamed after you link the doc.
  4. This was successful in Office 2007. I didn’t check with previous office versions.

Getting the word document ready.

  1. Select the text you want to show when the link is clicked on the excel file.
  2. Select the “Insert” tab and click on “Bookmark” under “Links
    word1
  3. Give a name for the bookmark. For easy reference I use the selected wording as the name for the bookmark. Now click on “Add”.
    word2
  4. You are done with the document.

Linking it with the excel file.

  1. Open the excel file and select the cell you want to link with the word document.
  2. Right-click on the cell and select “Hyperlink”.
    excel1
  3. In the “Insert Hyperlink” dialog box select “Existing File or Web Page” then “Current Folder” and then select the file. Once the file is selected you will need to point to the bookmark in the word file. So after the name of the document add “#Testing” (where testing is the name of your bookmark).
    excel2
  4. So the Address bar in the bottom will contain something like the following.
    c:\testing\testing.doc#Testing
  5. Click on “OK” and you should be all set.

Good luck

Advertisements