Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations IDS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excell into word, clipping sheet

Status
Not open for further replies.
ryanmech

ryanmech

Mechanical
Apr 8, 2003
68
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
 
Replies continue below

Recommended for you

Sort by date Sort by votes
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
okay thanks

i will approach microsoft and ask them the question

Cheers

Ryan
 
Upvote 0 Downvote
Ryan, Let us know how you get on with Microsoft, because I haven't solved it yet either.
macajm
 
Upvote 0 Downvote
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.
<<<
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

3DDave
  • Locked
  • Question
Python now integrated into Excel - apparently
Replies
8
Views
577
IDS
IDS
drawoh
  • Locked
  • Question
Insert Custom Info into Excel Footer
Replies
6
Views
128
drawoh
drawoh
dgallup
  • Locked
  • Question
Ancient spread sheet formats 1
Replies
13
Views
138
oldrunner
oldrunner
142846
  • Locked
  • Question
excel spread sheet 3
Replies
11
Views
132
SkipVought
SkipVought
hootrpootr
  • Locked
  • Question
3D Bolt Load Distribution Spread Sheet 1
Replies
6
Views
290
goutam_freelance
goutam_freelance

Part and Inventory Search

Sponsor

Back
Top Bottom