Inserted Excel Worksheet won't display all columns

Using Excel & Word 2000, I have inserted several worksheets into a document.

The worksheets function as expected; I can double-click and open them from
the Word Doc, edit, etc. When not in Excel mode, they appear as expected in
the Word doc, where I can resize them as objects..

However, with a couple of the worksheets, some of the columns to the right
side won't display. Attempting to get them to display with the method I
expect to work gives a nutty result -- the columns are hidden again when I
move from Excel mode to Word mode.

Here's what I 'm doing / how I expect to get the columns to show (which
fails):

1. In Word, insert the worksheet using Insert Object From File
2. Initially, the object is wider than the margins, but much of it appears
just fine outside the left margin. However, one or more columns don't appear.
3. Dragging the lower corner diagonally upwards (holding shift), I resize
the object (proportionally) so that it all fits well onto the page.
4. I double-click on it to open it in Excel.
5. Then, grabbing the resize/handlebar on the left edge, I pull to the left,
exposing columns.
-- When I let go, however,the handlebar snaps back to the position it was
in, re-hiding the columns I wanted. (I'm still in Excel.)

I have also tried to right click on the object, to choose "Format Object"
where I try combinations with Resizing "Size & Rotate" vs. "Scale" and I
can't get it to do anything but resize the object (not change the display
size setting of the object content WITHIN the allocated object display size).

Both the excel file and the word file were created originally in Office97;
however, I have recreated the results using Office2000 new documents.

Again, working with a dozen files, it happens consistently with some of
them, and never with the others. I have also checked, using Excel, the print
settings and worksheet display size.

The one thing that did work was to reduce all the columns to a tiny width,
insert it, then open it and reformat. This gives me access to all the
columns. But for my purposes here, that's not a practical solution. (We can't
re-do all column width settings every time we re-insert it.)

Any ideas?

Hi =?Utf-8?B?QW5keQ==?=,

This was a common problem with all versions of Word until 2002/2003. In a
nutshell, Word seems to calculate and set the maximum number of rows/columns
that can be accommodated on a page, and won't let you exceed that.

In Word 2002/2003 the process is much more dynamic, and Word actually reduced
the "zoom" by 50% (and again by 50%, if necessary) so that all the columns/rows
will fit on the page.

Using Excel & Word 2000, I have inserted several worksheets into a document.

The worksheets function as expected; I can double-click and open them from
the Word Doc, edit, etc. When not in Excel mode, they appear as expected in
the Word doc, where I can resize them as objects..

However, with a couple of the worksheets, some of the columns to the right
side won't display. Attempting to get them to display with the method I
expect to work gives a nutty result -- the columns are hidden again when I
move from Excel mode to Word mode.

Here's what I 'm doing / how I expect to get the columns to show (which
fails):

1. In Word, insert the worksheet using Insert Object From File
2. Initially, the object is wider than the margins, but much of it appears
just fine outside the left margin. However, one or more columns don't appear.
3. Dragging the lower corner diagonally upwards (holding shift), I resize
the object (proportionally) so that it all fits well onto the page.
4. I double-click on it to open it in Excel.
5. Then, grabbing the resize/handlebar on the left edge, I pull to the left,
exposing columns.
-- When I let go, however,the handlebar snaps back to the position it was
in, re-hiding the columns I wanted. (I'm still in Excel.)

I have also tried to right click on the object, to choose "Format Object"
where I try combinations with Resizing "Size & Rotate" vs. "Scale" and I
can't get it to do anything but resize the object (not change the display
size setting of the object content WITHIN the allocated object display size).

Both the excel file and the word file were created originally in Office97;
however, I have recreated the results using Office2000 new documents.

Again, working with a dozen files, it happens consistently with some of
them, and never with the others. I have also checked, using Excel, the print
settings and worksheet display size.

The one thing that did work was to reduce all the columns to a tiny width,
insert it, then open it and reformat. This gives me access to all the
columns. But for my purposes here, that's not a practical solution. (We can't
re-do all column width settings every time we re-insert it.)

Any ideas?


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)