Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts

    Excel link in Word (XP, SP1)

    I want to create an Excel link in a Word document. I've selected and copied the cell in Excel, and then pasted it into the Word document. I chose to paste with destination formatting and link to Excel. Once I do this, the field has paragraph marks both before and after it. Although I expect the field to appear mid-line in a Word paragraph, it now appears on a new line by itself. If pasting into a table in Word, the row height expands to allow room for <paragraph>, field, <paragraph>.

    I can delete (sometimes delete works, other times backspace... the wrong choice leaves the value but deletes the link) the paragraphs, but when the link is updated -- as is obviously necessary -- the paragraphs return.

    Any idea why this occurs and how it can be avoided?

    Thanks,
    Richard Barrett

  2. #2
    New Lounger
    Join Date
    Nov 2002
    Location
    Belleville, Illinois, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel link in Word (XP, SP1)

    Hi Richard,
    I am not familiar with (XP), however, I am able to accomplish what you want using (2K) and thought it may be helpful to tell you how I did it. First of all, it sounds like you may be pasting the entire excel cell versus its content only. Using 2K, I copy the cell from excel and using the "paste special" command on the edit menu, I paste link the cell as unformatted text. This works both when pasting into a word sentence or a word table. The pasted information takes on the font type and size of the word document, places it where the cursor is, and the links work fine. Hope this helps.

    Gerry <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts

    Re: Excel link in Word (XP, SP1)

    Gerry,

    The problem is unique to Word XP. The steps you outline work fine in Word 97 and 2000. In Word 2002, one pastes as usual and then the smart tag appears, offering among its choices "Match destination formatting and link to Excel." This causes the extraneous paragraphs. I've discovered that Insert|Field, and then Link + the manually entered file name and cell address links the info without the extraneous paragrahs, but it uses the formatting from the Excel spreadsheet. The smart tag, the new feature, appears to be the problem. Maybe no one tested it. :-)

    Richard

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel link in Word (XP, SP1)

    Hi Richard:
    I'm not familiar with 2002 either. However, instead of pasting & waiting for a smart tag to appear, can you use paste special from the edit menu as Gerry suggested? There should be a way of linking unformatted text to an Excel cell, even in 2002 (but I've assumed too much before <img src=/S/grin.gif border=0 alt=grin width=15 height=15>).

  5. #5
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts

    Re: Excel link in Word (XP, SP1)

    Yes, it does. Thank you.

    When I tried Past Special, I selected Microsoft Excel object, which of course gave me an embedded object. I was assuming that "unformatted text" meant "text"... which I didn't take to be a link.

    The smart tags are supposed to be the wave of the future, but I've learned -- through experience -- to be very suspicious of them.

    Thanks again,
    Richard

  6. #6
    New Lounger
    Join Date
    Nov 2002
    Location
    Belleville, Illinois, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel link in Word (XP, SP1)

    Richard,

    After reading your response to Phil's message, I gather the problem is fixed or at least you have a workable solution which bypasses the "smart tags". Phil has come to my rescue on several ocassions. We are haveing XP installed here shortly; guess I have a lot of learning to do. Woody's lounge has been extremely helpful in pointing out many anomolies and providing top notch solutions.

    Gerry <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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