Do you know why it does this or what I can do to stop it from expanding?
Thanks.
--
Henk57
Any ideas?
Make sure you have the aspect ratio locked. You can do this in Format
Object (check both "lock aspect ratio" in the Size tab, and "Relative
to original picture size").
If you have dynamically linked, it's not necessary to call Excel from
within Word, but open the source (xls) file. Then make the changes,
and the Word document shd reflect them without changing the size of the
table.
--
Henk57
Jfox
I stand corrected on my previous statement that your solution doesn't work.
It does work if you keep the in line with text provision. Centering the
spreadsheet seems to be the problem. It is not as pretty as when you can
center the spreadsheet but it does keep Word from resizing the spreadsheet.
Thanks for your information.
jfox
Copy the cells (in excel)
In word
Paste special>linked>as picture
'Will probably default to inline pic, I usually want floating
Right click>Format 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 click>Format object>'Size' tab
Change height to 100%, width to 100%
Select 'OK'
Right click>Format 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 Edit>Links you will have to repeat the above process.
8 months better late than never!
I want the object size to remain at 100%, the scale changes everytime I open
the Word document. For each linked excel object I have to go to format
Object, Size and reset. It resets to 100%. The locked ratio is not checked
and the relative to original picture is not checked.