Excell into word, clipping sheet

Question

Excell into word, clipping sheet

ryanmech (Mechanical)

(OP)

9 May 04 23:10

This problem is frustrating the hell out of me.

I am trying to insert a linked spreadsheet to a word document. To do this i am using insert, object, create from file, link to file. When i insert it, the spreadsheet displays with only the top ten lines of the sheet. I cannot get the bloody thing to show the rest of the sheet. The sheet is larger than a page, and would need to be about 45% of its actual size to be displayed on a word-doc single page. It is like the spread sheet is being clipped on insertion into the word doc...

I think it must be a variable setting somewhere, because i did not have this problem previously. Mind you it would have been a earlier version the last time i inserted a linked spreadsheet into a word doc.

Any help would be much appreciated

Ryan

IRstuff (Aerospace) · Answer 1 · 2004-05-10 03:24:01

If you double click on the object, you should then be able to adjust the displayed window size.

DO NOT adjust the object handles UNLESS you're editing the object, you'll just wind up with a differently sized copy of what you started with.

TTFN

ryanmech (Mechanical) · Answer 2 · 2004-05-11 01:13:55

No go IRstuff

If i double click on the object it opens the 'linked file' in excell.....

Where as if i double click a spreadsheet that is not linked then i can simply change the size of the view port. (autocad terminology). by double clicking the object then grabbing the grips and stretching them while in edit...

Ryan

brengine (Mechanical) · Answer 3 · 2004-05-11 20:17:33

Insert it into the Word Doc a the following way instead:
-Open the Excel file
-Highlight what you want to insert
-Copy
-Switch to the Word Doc
-Go to Main Menu\Edit\Paste Special
-Select the "Paste Link" radio button
-Choose "Microsoft Excel Worksheet Object"

There you go.
Ken

ryanmech (Mechanical) · Answer 4 · 2004-05-12 19:00:16

thanks Ken but....

Unfortunately i have already tried, paste special with paste linked box ticked, and excell selected. This way it shows over half the spreadsheet i had selected but not the whole selection. This makes me think that there is a setting somewhere which i have not found as yet. Maybe a setting like: automatically clip the object to fit in a single page?

Where as before when i had tried to insert an object linked.. the object inserted only showed approximately the top ten lines of the sheet..

have also tried on a different doc, with no difference...

thanks
ryan

brengine (Mechanical) · Answer 5 · 2004-05-13 22:34:27

Ryan,

I see your problem now, I gave it a try and it didn't work for me either. I tried changing my Word doc sheet size to something really big, but when I inserted the Excel stuff it was still clipped even tho it didn't fill the doc from margin-to-margin. I guess I've never inserted such a large number of cells before to notice.

Could you instead insert your Excel stuff in chunks?

Ken

jalvarez (Chemical) · Answer 6 · 2004-05-14 09:03:43

Ryan, Ken:
I've experienced with your problem and I see an extra issue:
If the origin excel file is open, only ten rows are pasted, and updated later if you modify the origin file, etc.
If the excel spreadsheet is closed when I make the Insert/Object/Create from file, Link to file, etc. in the Word document, previously and conveniently enlarged to fit what I want to insert, the amount of lines increases to 26!
Maybe this extension solve your particular problem, but the question remains there. I'm keeping trying...
I have
Windows 2000
Word & Excel 2002

Best regards
J.Alvarez

jalvarez (Chemical) · Answer 7 · 2004-05-14 09:37:12

And with the columns it happens the same, but in a reduced extent. If the origin excel file is open when the link is created, there appear only seven columns (G). Eight (H) if it's closed.
It seems to me that we are scrapping the limits...
Best regards again

ryanmech (Mechanical) · Answer 8 · 2004-05-16 16:45:28

okay thanks

i will approach microsoft and ask them the question

Cheers

Ryan

macajm (Mining) · Answer 9 · 2004-05-16 23:24:41

Ryan, Let us know how you get on with Microsoft, because I haven't solved it yet either.
macajm

brengine (Mechanical) · Answer 10 · 2004-06-01 01:28:18

I saw the below post for inserting an Excel OLE Object into a SolidWorks drawing (posted in a SolidWorks forum thru Google). The original poster was having the same problem, only a certain number of lines was visible no matter what he tried. I have not tried it out for this particular problem tho, i.e. inserting into Word, but I thought I'd throw this out there.

Ken

>>>
It's a MS OLE limitation. Lovely isn't it?

If you really want to insert it, you have to use a really tiny font and (then) scale up the inserted object.
<<<

Come Join Us!

Posting Guidelines

Excell into word, clipping sheet