Linking a cel from Excel to a Cell in a Word table

T

Terri

I am trying to link a cell in an Excel table to a cell in a Word table by
copying the cell in Excel then doing a paste in Word and selecting "Match
Destination Table Style and Link to Excel" option so it will update as Excel
is updated. In Word it is adding a line above and a line below the linked
data. Is there anything I can do so this doesn't happen?

Thanks in advance.
 
T

Terri

Ok it solved that problem but it lost the Word formatting. Is there
something that I can do to keep the Word formatting?
 
S

Sheeloo

Paste as 'Formatted Text' and choose 'Destination...' from the drop down you
get after clicking on the down arrow on 'Paste Options' ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Excel data to Word table 1
Copying a table from Word 5
Bring in Word table 2
Pasting from Word Table 3
Excel cell value equals selected text from Word 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Linking an Excel 2003 document copied to a Word 2003 document 7
Links in Word not working properly 4

Top