If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 Excel 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
|
|||
|
|||
How to make Word past a range with "Past link:" as with "Past:"?
Don't paste into a Word table. Paste the link into the word document. The
result will look like the table in Excel. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org 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 Excel 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
|
|||
|
|||
How to make Word past a range with "Past link:" as with "Past:"?
I do not want the second table in a Word document. I want to past the Excel
cell values to corresponding cells in the Word table. "Graham Mayor" сообщил/сообщила в новостях следующее: ... Don't paste into a Word table. Paste the link into the word document. The result will look like the table in Excel. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org 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 Excel 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:"? |
#4
|
|||
|
|||
How to make Word past a range with "Past link:" as with "Past:"?
Then you'd have to copy and paste each cell from the Excel range
separately (as links, as unformatted text) in the corresponding Word table. -- Stefan Blom Microsoft Word MVP "Dmitry Kopnichev" wrote in message ... I do not want the second table in a Word document. I want to past the Excel cell values to corresponding cells in the Word table. "Graham Mayor" сообщил/сообщила в новостях следующее: ... Don't paste into a Word table. Paste the link into the word document. The result will look like the table in Excel. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org 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 Excel 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:"? |
#5
|
|||
|
|||
How to make Word past a range with "Past link:" as with "Past:"?
Thanks for your reply.
I have been pasting each cell separately for a year. Why can not Excel past with "Past link:" a range as with "Past:"? "Stefan Blom" сообщил/сообщила в новостях следующее: ... Then you'd have to copy and paste each cell from the Excel range separately (as links, as unformatted text) in the corresponding Word table. -- Stefan Blom Microsoft Word MVP "Dmitry Kopnichev" wrote in message ... I do not want the second table in a Word document. I want to past the Excel cell values to corresponding cells in the Word table. "Graham Mayor" сообщил/сообщила в новостях следующее: ... Don't paste into a Word table. Paste the link into the word document. The result will look like the table in Excel. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org 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 Excel 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:"? |
#6
|
|||
|
|||
How to make Word past a range with "Past link:" as with "Past:"?
Since you can paste a Word table as a link in an Excel range, but not
the other way around, I'd say that the limitation is with Word. I don't know anything about the reason, though. For some reason, Word was designed like this. -- Stefan Blom Microsoft Word MVP "Dmitry Kopnichev" wrote in message ... Thanks for your reply. I have been pasting each cell separately for a year. Why can not Excel past with "Past link:" a range as with "Past:"? "Stefan Blom" сообщил/сообщила в новостях следующее: ... Then you'd have to copy and paste each cell from the Excel range separately (as links, as unformatted text) in the corresponding Word table. -- Stefan Blom Microsoft Word MVP "Dmitry Kopnichev" wrote in message ... I do not want the second table in a Word document. I want to past the Excel cell values to corresponding cells in the Word table. "Graham Mayor" сообщил/сообщила в новостях следующее: ... Don't paste into a Word table. Paste the link into the word document. The result will look like the table in Excel. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org 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 Excel 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:"? |
#7
|
|||
|
|||
How to make Word past a range with "Past link:" as with "Past:"?
Thanks for your reply.
"Stefan Blom" сообщил/сообщила в новостях следующее: ... Since you can paste a Word table as a link in an Excel range, but not the other way around, I'd say that the limitation is with Word. I don't know anything about the reason, though. For some reason, Word was designed like this. -- Stefan Blom Microsoft Word MVP "Dmitry Kopnichev" wrote in message ... Thanks for your reply. I have been pasting each cell separately for a year. Why can not Excel past with "Past link:" a range as with "Past:"? "Stefan Blom" сообщил/сообщила в новостях следующее: ... Then you'd have to copy and paste each cell from the Excel range separately (as links, as unformatted text) in the corresponding Word table. -- Stefan Blom Microsoft Word MVP "Dmitry Kopnichev" wrote in message ... I do not want the second table in a Word document. I want to past the Excel cell values to corresponding cells in the Word table. "Graham Mayor" сообщил/сообщила в новостях следующее: ... Don't paste into a Word table. Paste the link into the word document. The result will look like the table in Excel. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org 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 Excel 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:"? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
take yet another lesson from wordperfect "reveal codes" | wordperfect is superior | General Discussion | 5 | May 11th, 2009 07:58 PM |
hard space between words. | Sandy L | General Discussion | 7 | May 5th, 2006 08:25 PM |
Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 12:36 AM |
Does Word have a QuickCorrect/Quick Word option like WordPerfect? | CW | New Users | 2 | December 20th, 2005 05:54 PM |
Envelope Address | GR | New Users | 5 | April 24th, 2005 09:48 PM |