Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Java Junkie Java Junkie is offline
external usenet poster
 
Posts: 1
Default How do I size an embedded Excel OLE and keep it that way in Word

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?
  #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?



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Java Junkie[_2_] Java Junkie[_2_] is offline
external usenet poster
 
Posts: 1
Default How do I size an embedded Excel OLE and keep it that way in Wo

Graham, that worked fine. Thank you for giving me help on my problem.





"Graham Mayor" wrote:

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?



.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dot template with embedded excel refuses to recognise excel when d Ian Michael Microsoft Word Help 0 July 17th 09 02:18 PM
excel embedded in word lost in hawaii Microsoft Word Help 0 August 21st 08 09:59 PM
Embedded Excel object in Word Saga New Users 4 August 9th 08 06:59 PM
Excel embedded into Word: object size problem e-csl Microsoft Word Help 2 July 18th 07 07:46 PM
How can I save an embedded Excel file in word back into an Excel Gbelly Microsoft Word Help 1 August 11th 05 05:31 PM


All times are GMT +1. The time now is 04:06 AM.

Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"