View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default How do I size an embedded Excel OLE and keep it that way in Word

When you paste special - try choosing the bitmap object and check the link
box. You can then re-size the inserted object and it will stay that way.
Changes you make in the spreadsheet will be reflected in the bitmap, which
should remain the same size..

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"Java Junkie" Java wrote in message
...
I copy and paste special an Excel worksheet with multiple tabs into word on
a
sheet. I size the Excel sheet while it is open in Excel and then double
click
outside it to close it. Everything looks good. I do this on three
consecutive sheets. When I go back to one of them and double click to
make a
change in the Excel sheet it opens way larger than it was and causes it to
advance onto another sheet. I have to resize it but they just don't stay
sized when re-opening. How do I fix this?