Linking Excel data into a Word document

[Linus]

I have linked a portion of an excel spreadsheet in my Word
document by copying from Excel and Paste special in Word.
The problem is that I seem to be limited in the number of
columns that display in the Word representation of the
data.

I have tried this on two computers and encounter a
different limit on each machine. One will display about
10 - 12 columns, the other about 18 - 20.

I can Hide some of the columns in the excel version and
the remainder will then show in the Word version.

The Excel help menu indicates that you can link entire
spreadsheets to a Word documnet, yet I can only display a
few columns.

 

[Doug Robbins - Word MVP]

Hi Linus,

There is a limit.

Please respond to the newsgroups for the benefit of others who may be
interested.

Hope this helps
Doug Robbins - Word MVP

 

[Bob S]

I have linked a portion of an excel spreadsheet in my Word
document by copying from Excel and Paste special in Word.
The problem is that I seem to be limited in the number of
columns that display in the Word representation of the
data.

I have tried this on two computers and encounter a
different limit on each machine. One will display about
10 - 12 columns, the other about 18 - 20.

I can Hide some of the columns in the excel version and
the remainder will then show in the Word version.

The Excel help menu indicates that you can link entire
spreadsheets to a Word documnet, yet I can only display a
few columns.

You didn't mention versions.

My understanding is that Word 2000 and earlier don't scale the copy,
and the only way that sometimes works to get more columns is to reduce
column widths and font sizes in Excel before copying.

Word 2002 pastes a scaled copy, so you get all the columns, but they
may be too small to read.

Bob S