Excel to Word cutoff!!!

[Felix Schwabedal]

Hello everybody,

this is driving me WILD! I'm on my diploma thesis and I need to put in a
table edited in Excel into Word - landscape format since the table is rather
wide.
Sounds simple.
Insert object...Excel-table...and the table's in there.
BUT
the table is cut off where it would be cut off if I had not set it to
landscape-format which leaves me with only half of my table (and 2 hours
less to work on my thesis - which is even worse).

Hopefully, one of you can help me - running out of time...

Thanks,
Felix

 

[Elliott Roper]

Hello everybody,

this is driving me WILD! I'm on my diploma thesis and I need to put in a
table edited in Excel into Word - landscape format since the table is rather
wide.
Sounds simple.
Insert object...Excel-table...and the table's in there.
BUT
the table is cut off where it would be cut off if I had not set it to
landscape-format which leaves me with only half of my table (and 2 hours
less to work on my thesis - which is even worse).

Hopefully, one of you can help me - running out of time...

Das ist einfach.
Create a new section in Word and set its orientation to landscape.
Pay attention to page numbers and header and footer titles to make sure
that following portrait section is still OK.

Also, if you plan to publish in PDF, then you may need to reassemble the resultant separate
PDF documents that Word will create. (There is shareware out there for doing that).

 

[Felix Schwabedal]

Das ist einfach.
Create a new section in Word and set its orientation to landscape.
Pay attention to page numbers and header and footer titles to make sure
that following portrait section is still OK.

Also, if you plan to publish in PDF, then you may need to reassemble the
resultant separate
PDF documents that Word will create. (There is shareware out there for doing
that).

Thanks for your answer!

Das hatte ich schon ausprobiert

I did that already. The explanation of my problem was incomplete since I was
rather upset at that time.

When I put the Excel-table into the landscape-format Word-page, the object
is there in its entire size (I can see the borders when it is activated) BUT
the table is merely visible to the point where it would have been cut off,
if I would have put it into a normal format.

To me, this looks like a bug in Word.

Best regards,
Felix

 

[Elliott Roper]

Thanks for your answer!

Das hatte ich schon ausprobiert

I did that already. The explanation of my problem was incomplete since I was
rather upset at that time.

When I put the Excel-table into the landscape-format Word-page, the object
is there in its entire size (I can see the borders when it is activated) BUT
the table is merely visible to the point where it would have been cut off,
if I would have put it into a normal format.

To me, this looks like a bug in Word.

OK Versuchen Sie dieses. ;-)
Start with Excel
Adjust the orientation margins and columns and font size in the Excel
workbook. Save it
Then when you perform insert->object, choose "from file" at the bottom
left of the insert object panel. The object should then be landscape.
It remains editable from Word. When you doulbe-click on it, the Excel
sheet appears and the changes you make in it appear in the Word
document.


(I was forced to use the dashboard translator this time. I really don't
speak too much German)