Embedded Excel Objects in Word are not Consistent

[vinceh]

I have several linked excel 2003 objects in a word 2003 document that have
very specific size requirements. To accomplish this, I set the margins in
Excel to equal the width of the table I need in Word, so I can use the Excel
page breaks to gauge the width of the table.

Sometimes when I copy and paste the linked Excel object, it shows in Word
with a smaller width than I had in Excel, the fonts look the same as Excel,
but it prints as if it was condensed, which I don't want. Other times, it
pastes as the same width as I want in Excel, the fonts look stretched, but it
prints perfectly (as it appears in Excel).

A related issue is that sometimes when I open the same documents one time,
it'll show one way as described above; when I open it another time, it'll
show the other way as described above.

Does anyone know why this happens and how I can fix it?

 

[macropod]

Hi vinceh,

Try using Format|Object|Size and making sure the horizontaal and vertical scaling are the same (presumably 100%). You'll probably
need to uncheck the 'lock aspect ratio'box too.

 

[vinceh]

That's the problem. When the scaling is 100% on both horizontal and
vertical, the object is 0.5" smaller than how it is if I would have printed
it in Excel, the fonts look great on screen, but when I print, the fonts are
squished. Other times when I open the files, the scaling is 112% horizontal
and 102% vertical (without me or anyone else changing anything). This makes
the object width the same width as if I would've printed it in Excel, the
fonts look stretched on screen, but the fonts are perfect when I print.

If there's no way to get the fonts to look great on screen and when I print,
I would prefer to consistently get the second way (112% wide x 102% high).

Hi vinceh,

Try using Format|Object|Size and making sure the horizontaal and vertical scaling are the same (presumably 100%). You'll probably
need to uncheck the 'lock aspect ratio'box too.

--
Cheers
macropod
[MVP - Microsoft Word]

I have several linked excel 2003 objects in a word 2003 document that have
very specific size requirements. To accomplish this, I set the margins in
Excel to equal the width of the table I need in Word, so I can use the Excel
page breaks to gauge the width of the table.

Sometimes when I copy and paste the linked Excel object, it shows in Word
with a smaller width than I had in Excel, the fonts look the same as Excel,
but it prints as if it was condensed, which I don't want. Other times, it
pastes as the same width as I want in Excel, the fonts look stretched, but it
prints perfectly (as it appears in Excel).

A related issue is that sometimes when I open the same documents one time,
it'll show one way as described above; when I open it another time, it'll
show the other way as described above.

Does anyone know why this happens and how I can fix it?

 

[Harlan Grove]

That's the problem.  When the scaling is 100% on both horizontal and
vertical, the object is 0.5" smaller than how it is if I would have
printed it in Excel, the fonts look great on screen, but when I
print, the fonts are squished. . . .

When you say 'on screen', do you mean in Normal view, Page Break
Preview or in Print Preview?

Try something as a check: bring up a new, blank Word document, and
insert the Excel objects each into separate pages, ensure each is 100%
h&v, then print the document. Do they print correctly then? If not,
then I'm at a loss, but if they do, then if there are any pages in
your original document that show multiple Excel objects, gather those
objects together in the same pages in the new document, and print it
again. Do they print correctly? If not, then it'd seem to be a problem
in Word dealing with multiple objects on the same page, and you'll
need to play around with scaling to produce the best printed results.
No alternative to trial & error if that's the case.

But if the new document prints OK, then the expedient option may be to
copy the other content from your original document and place it around
the Excel objects in the new document and check how that work in
printout.

Other times when I open the files, the scaling is 112% horizontal
and 102% vertical (without me or anyone else changing anything).
This makes the object width the same width as if I would've printed
it in Excel, the fonts look stretched on screen, but the fonts are
perfect when I print.

...

This is making me think that Word and Excel have different zoom
settings or Word is compressing page images to fit them into your page
margins. One thing to check.

 

[vinceh]

Does anyone know how to check the zoom settings in Excel and Word?

 

[macropod]

You check the zoom settings by looking at the 'Standard' toolbar.

In any event, thse have no effect on the print size or the relative sizes of embedded objects.