Linked Excel - Sizing in Word

[Guest]

Hi,
When I bring linked excel data into Word, Word automatically changes the
size of the object(worksheet). I've set up the Excel sheet with the exact
page dimensions as the Word document, and formatted the Excel to layout the
way I want within those margins. So when I bring it into Word, I don't want
word to change the size of the object, but it always does. I want it to be
100%x100%. How can I make this happen?

 

[John McGhie [MVP - Word and Word Macintosh]]

You need to set up the Excel sheet to allow for the document margins. Word
will resize an imported object to fit between the available document
margins.

Hi,
When I bring linked excel data into Word, Word automatically changes the
size of the object(worksheet). I've set up the Excel sheet with the exact
page dimensions as the Word document, and formatted the Excel to layout the
way I want within those margins. So when I bring it into Word, I don't want
word to change the size of the object, but it always does. I want it to be
100%x100%. How can I make this happen?

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant
Technical Writer.
Sydney, Australia +61 (0) 4 1209 1410