View Single Post
  #2   Report Post  
Posted to microsoft.public.word.application.errors,microsoft.public.word.oleinterop,microsoft.public.word.tables
Cooz
 
Posts: n/a
Default How to make Word past a range with "Past link:" as with "Past:"?

Hi Dmitry,

You cannot do this. Check Tools | Options | tab View | Field codes to see
why: the range of cells will have become one field. You cannot spread one
field over multiple cells in a Word table.

Perhaps you can make up the data in Excel the way you like to have it in
Word, and paste this in Word - in other words replace the entire Word table
by the Excel table. Probably you may have thought of this as well.

Good luck,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.


"Dmitry Kopnichev" wrote:

Hello
I'm trying to past an Excel range of cell values in to a Word table with a
link to the Excel range of cells, but Word pasts the range in to only one
cell. I select a range with the same orientation, configuration and same
number of cells in the Word table, click "Past special" and "Past link:" for
this. Word 2003 sp2 pasts the range in to a range of the same size if I
click "Past special" and "Past:", not "Past link:". How to make Word past
with "Past link:" in to a range (not to only one cell) as with "Past:"?