Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
hyperlink to a cell in an Excel table
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
hyperlink to a cell in an Excel table
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). -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "FMAS" wrote in message ... 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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
hyperlink to a cell in an Excel table
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. -- Enjoy, Tony "FMAS" wrote in message ... 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 |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
hyperlink to a cell in an Excel table
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). -- Peter Jamieson http://tips.pjmsn.me.uk "Tony Jollans" My forename at my surname dot com wrote in message ... 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. -- Enjoy, Tony "FMAS" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking an Excel Pivot table / cell range into Word | Microsoft Word Help | |||
Cell referencing in table formulas - just ONE adjacent cell | Tables | |||
How do I get Excel information inserted into Word Table cell? | Microsoft Word Help | |||
How do I move from cell to cell iin a table column in Word 2003? | Tables | |||
How do I auto copy data from cell in a word table to another cell. | New Users |