hyperlink to a cell in an Excel table

[FMAS]

Does someone know how I could put in a word document an hyperlink to a
cell (not just a sheet) in an Excel table?

Francois

 

[Herb Tyson [MVP]]

The easiest way I know of:

1. Select the cell in Excel, and press Ctrl+C to copy it to the clipboard.

2. In Word, choose Edit - Paste Special - Microsoft Office Excel Worksheet
Object.

3. Click the Paste link option.

4. Click OK.

This will paste just the selected cell. When/if that cell changes in Excel,
the corresponding cell in Word will also change (you might need to select
the cell in Word and press F9 to expedite its being updated).

 

[Tony Jollans]

You *ought* to be able to add the cell as a sub-address - append a #
character followed by the cell address to the hyperlink but, AFAIK, it has
never worked properly.

 

[Peter Jamieson]

I can't say I've looked at this for more than a few minutes, so there are
doubtless all sorts of problems in this area.

What seems to work in Word 2007 is...

A. Adding an \l switch in the HYPERLINK field (then reselecting the field
and pressing F9) like

\l "R6C5"

\l "E6"

\l "sheetname!R6C5"

\l "sheetname!E6"

Using a # instead of the ! seems to result in an invalid reference message.

B. Appending a cell reference to the file name in the Hyperlink field (then
reselecting the field and pressing F9) using e.g.

!R6C5

(but not !E6, nor is it obvious how to specify a sheet if you do that).

If you try #R6C5 instead, it works until you close and re-open the document,
at which point Word has modified the URL, changed # to %23 and it no longer
works (Changing Word's "Update links on save" option does not obviously help
in this case).