Article ID: 111748
Article Last Modified on 1/18/2007
APPLIES TO
- Microsoft Word 6.0 Standard Edition
- Microsoft Word 6.0a
- Microsoft Word 6.0c
- Microsoft Word 95 Standard Edition
- Microsoft Word 97 Standard Edition
This article was previously published under Q111748
SYMPTOMS
When you select a large range in a Microsoft Excel spreadsheet and paste or paste link it into Word as an Excel Worksheet Object or as a Picture, columns may be cropped from the right or rows may be cropped from the bottom. This may happen even though there appears to be enough room on the Word document page to accommodate the entire range selected.
CAUSE
A "picture" and the presentation of an embedded object are Windows metafiles. The Windows operating system limits the height and width of a Windows metafile. Microsoft Excel sets the height and width of the picture or object presentation by using the Microsoft Excel page size at 100- percent zoom. If the selection in Microsoft Excel exceeds approximately 20 columns (the default width) or approximately 75 rows, the resulting picture will not reflect the entire selection. Word will scale the picture when it is pasted into the document so it may appear that there is room on the page to accommodate a larger picture.
WORKAROUND
Method 1: Paste or paste link formatted or unformatted text into Word.
Method 2: Reduce the font and column size in Microsoft Excel.
Additional query words: OLE winword word6 word7 word95 cut drop truncate
Keywords: KB111748
