View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Links from Excel create extra lines in Word table

Hi Sabine,

You might get better results using Edit|Paste Special, with the 'Paste link'
and 'Unformatted Text' options, which will cause the link to apply the
destination formatting. Alternatively, you could construct the whole table
in Excel, with the desired destination formatting, and paste the link as an
Excel object.

Cheers

--
macropod
[MVP - Microsoft Word]


"Sabine M." Sabine wrote in message
...
I've been trying to link data from an Excel spread sheet to a table in a

Word
template by copying and pasting the text or numbers with the 'Match
destination formatting and link to Excel' option.

The linking works fine, but whenever I change the data in Excel or close

and
re-open the Word document, extra lines seem have been created before and
after the link in the word table. Any idea why this is happening? Or how I
can create the links in a different way?

Thanks.