How do I size an embedded Excel OLE and keep it that way in Word

[Java Junkie]

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?

 

[Graham Mayor]

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Java Junkie]

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