Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2004
    Location
    New York, New York, Zambia
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link in Word to Excel (Word & Excel 2002)

    When I create link in a Word file to display up-to-date data from an Excel file (by copying the data in Excel, pasting it into Word and setting the Paste options to "Link to Excel"), a paragraph mark is also inserted. I can delete this but it comes back automatically. Is it possible to have the link sit in a line of text without a pilcro immediately following? If so, how. Many thanks.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Link in Word to Excel (Word & Excel 2002)

    Hi,

    I don't get this behaviour with Word 2000 - the linked object inserts into the document without an extraneous para mark, and this doesn't change with an update. Changing between 'spare' and 'in-line with text' doesn't seem to have any effect either.

    Are you sure the extraneous para marker isn't in your Excel worksheet? For example, a cell that ends with a line feed - could be a cell with char(10), or an Alt-enter key combination at its end.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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