Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 110
Default Linking a cel from Excel to a Cell in a Word table

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 225
Default Linking a cel from Excel to a Cell in a Word table

Try (in Word)
Edit-Paste Special-Unformatted Text



"Terri" wrote:

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 110
Default Linking Excel to Word

Ok it solved that problem but it lost the Word formatting. Is there
something that I can do to keep the Word formatting?
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 225
Default Linking Excel to Word

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

"Terri" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Excel cell in Word 2003 J Mowad Excel Discussion (Misc queries) 0 May 27th 07 02:25 PM
LINKING CELL VALUES IN A EXCEL SHEET TO EMBEDDED WORD DOCUMENT Prasad Gopinath Excel Discussion (Misc queries) 0 February 13th 07 09:34 PM
Linking table in Excel to word travis Links and Linking in Excel 1 November 19th 05 03:30 PM
Embedding Word table in Excel cell Larry Lester New Users to Excel 3 October 24th 05 05:05 PM
Paste from Word table so that 1 table cell = 1 Excel cell Dave G Excel Discussion (Misc queries) 4 June 17th 05 12:16 AM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"