J
John M
I automate a report in Word 2002 with many linked objects from Excel. I have designed my Excel spreadsheets so that all objects are of a size that would neatly fit onto the Word page - thus I can set the size to 100% of the original size. But now every time I update links or reopen the file these linked objects change size, sometimes bigger than the set page margins. This make the report look sloppy. Sometimes it only changes the vertical, sometimes the horizontal, and sometimes both dimensions (even if I have selected lock aspect ratio)