Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.word.pagelayout
Taylor Bryant Taylor Bryant is offline
external usenet poster
 
Posts: 1
Default Excel Worksheet Object resizes in Word when Iedit/open it - Size matter

Screwy workaround - I do a lot of this linking.

Copy the cells (in excel)

In word

Paste speciallinkedas picture

'Will probably default to inline pic, I usually want floating

Right clickFormat object'Size' tab
'In mine, it always pastes cells scaled at 98% height, 105% width, [with charts, not a problem]
Uncheck 'Lock Aspect Ratio'
Select 'OK'

Right clickFormat object'Size' tab
Change height to 100%, width to 100%
Select 'OK'

Right clickFormat object'Size' tab
Check 'Lock Aspect Ratio'
Select 'OK'

You have to do these three steps discretely - and manually (I have had no luck changing these settings via VBA, except using sendkeys).

If you do these three, then you can go back in, adjust to whatever scale you need (say 90%/90%) and when updating the link, the size will not reset and go all screwy.

Note: if you "Change Source" via EditLinks you will have to repeat the above process.

8 months better late than never!
 
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
Pasting a Microsoft Office Excel Worksheet Object into Word jfox Microsoft Word Help 1 May 2nd 06 04:49 PM
Use an object linking to disply Excel worksheet data as a word tab mar Tables 1 March 22nd 06 09:30 PM
how do I open and edit an excel worksheet Rahul0901 Microsoft Word Help 1 February 17th 06 08:55 PM
edit inserted excel worksheet in word doc Sonja Microsoft Word Help 2 July 19th 05 02:51 PM
paste as EXCEL Worksheet Object LCC Formatting Long Documents 4 April 16th 05 12:18 PM


All times are GMT +1. The time now is 08:37 AM.

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

About Us

"It's about Microsoft Word"