Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.application.errors,microsoft.public.word.oleinterop,microsoft.public.word.tables
Dmitry Kopnichev
 
Posts: n/a
Default How to make Word past a range with "Past link:" as with "Past:"?

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:"?


  #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:"?



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

Thanks for your reply.
The existing Word table is too large to recreate in Excel.
"Cooz" сообщил/сообщила в новостях
следующее: ...
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:"?





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
How to make Word past a range with "Past link:" as with "Past:"? Dmitry Kopnichev Tables 6 February 28th 06 10:24 AM
Line Spacing in Word Stephanie New Users 3 February 15th 06 09:17 PM
apply a template to existing documents Bubba Gump Shrimp Page Layout 2 July 28th 05 04:46 PM
Macros - Keyboard Commands Janet Microsoft Word Help 6 April 11th 05 05:28 AM


All times are GMT +1. The time now is 10:12 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ╘2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"