Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Links from Excel create extra lines in Word table
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. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
Converting Word Perfect forms to Word forms | Microsoft Word Help | |||
WP merge file to Word | Tables | |||
Inserting Excel tables into Word | Microsoft Word Help |