Paste Special Excel to Word - Size

[FDR_Texas]

In attempting to Paste Special an MS Excel Worksheet to Word, the pasted information is incomplete. That is, only 35 out of 45 rows are pasted.
If I do Paste only, without linking, it pastes correctly.
Any ideas why this is happening and how it might be corrected?
Thanks,
Fred

[Damon Ostrander]

Hi FDR_Texas,

I assume you are doing a Paste Special as a "Microsoft Excel Worksheet Object", in which case the cell range you copied will become an embedded worksheet object (either linked or not). With such objects, even if you don't see the entire range you copied, not only is it there, but the entire workbook is actually there, embedded in the Word document. When you double-click on this object in Word it will open it for display/editing in Excel. If you want to change the range of cells that is displayed at this time, simply use the drag points on the edges of this box to resize the area to include the rows and columns you want to display in Word.