Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Dynamically link Excel to Word - (paste as link wont fit need)

  1. #1
    Board Regular
    Join Date
    Apr 2005
    Posts
    70
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Dynamically link Excel to Word - (paste as link wont fit need)

    Hi there,

    Curious if anyone knows how to better dynamically link Excel to word. When you paste as link, the range of the cells linked is fixed in the word doc. So, for example, should you add a row in the excel table, the word document will not automatically update. I have tried pasted as link a named range but word doesn't let me.

    Basically, want to managed all adds/edits/deletes of data in an excel spreadsheet but have it automatically linked to word where there is other text/screenshots. Thanks for the help - C

  2. #2
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    2,957
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Dynamically link Excel to Word - (paste as link wont fit need)

    Hi cjc155,
    should you add a row in the excel table, the word document will not automatically update
    Not if you know how!
    I have tried pasted as link a named range but word doesn't let me
    OK, you've got a named range in Excel. That's a good start. So, paste the linked range into Word in the normal manner. Then, press Alt-F9 to expose the field code(If you've pasted as a linked Excel object, it may be formated as a floating object - you'll need to temporarily change that to 'in-line with text'). You'll see something like:
    Code:
    {LINK Excel.Sheet.8 "C:\\User\\Documents\\xlWkbk.xls" "Sheet1!R1C1:R10C10" \a \r}
    where "Sheet1!R1C1:R10C10" is the linked range. Simply replace that reference with the named range's name. Press F9, then Alt-F9 again, when you're done. From now on, if you redefine the named range, the linked object will expand/contract to match.

    Cheers
    Cheers
    Paul Edstein
    [MS MVP - Word]

  3. #3
    Board Regular
    Join Date
    Apr 2005
    Posts
    70
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dynamically link Excel to Word - (paste as link wont fit need)

    Thanks for the info. I will give that a shot but looks like I am all set. Thanks again - C

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •