How to make Word past a range with "Past link:" as with "Past:"?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dmitry Kopnichev - 26 Feb 2006 13:16 GMT

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

Reply to this Message

Graham Mayor - 26 Feb 2006 13:46 GMT

Don't paste into a Word table. Paste the link into the word document. The
result will look like the table in Excel.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hello
> I'm trying to past an Excel range of cell values in to a Word table
[quoted text clipped - 5 lines]
> not "Past link:". How to make Word past with "Past link:" in to a
> range (not to only one cell) as with "Past:"?

Reply to this Message

Dmitry Kopnichev - 26 Feb 2006 14:27 GMT

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.

> Don't paste into a Word table. Paste the link into the word document. The
> result will look like the table in Excel.
[quoted text clipped - 8 lines]
> > not "Past link:". How to make Word past with "Past link:" in to a
> > range (not to only one cell) as with "Past:"?

Reply to this Message

Stefan Blom - 27 Feb 2006 13:22 GMT

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.

Signature

Stefan Blom
Microsoft Word MVP

> 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.
[quoted text clipped - 10 lines]
> > > not "Past link:". How to make Word past with "Past link:" in to a
> > > range (not to only one cell) as with "Past:"?

Reply to this Message

Dmitry Kopnichev - 27 Feb 2006 13:32 GMT

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

> Then you'd have to copy and paste each cell from the Excel range
> separately (as links, as unformatted text) in the corresponding Word
[quoted text clipped - 25 lines]
> a
> > > > range (not to only one cell) as with "Past:"?

Reply to this Message

Stefan Blom - 27 Feb 2006 14:05 GMT

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.

Signature

Stefan Blom
Microsoft Word MVP

> Thanks for your reply.
> I have been pasting each cell separately for a year. Why can not Excel past
[quoted text clipped - 28 lines]
> > a
> > > > > range (not to only one cell) as with "Past:"?

Reply to this Message

Dmitry Kopnichev - 28 Feb 2006 10:24 GMT

Thanks for your reply.

> 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
[quoted text clipped - 43 lines]
> > > a
> > > > > > range (not to only one cell) as with "Past:"?

Reply to this Message