Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.application.errors,microsoft.public.word.oleinterop,microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.application.errors,microsoft.public.word.oleinterop,microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.application.errors,microsoft.public.word.oleinterop,microsoft.public.word.tables
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
How to make Word past a range with "Past link:" as with "Past:"? | Tables | |||
Line Spacing in Word | New Users | |||
apply a template to existing documents | Page Layout | |||
Macros - Keyboard Commands | Microsoft Word Help |