Embedding Excel worksheet objects directly into Word seems like a killer feature to me, but it would only be useful for publication if I could choose the "printable area" of the spreadsheet that gets fitted to the frame in Word. For the life of me I cannot figure out how to do this. Word only likes to show the first handful of cells in the top left corner. Resizing the frame just resizes these cells. Can this be done?
What version of Office are you using? How are you pasting these in?
In Office 2003, I can copy an area on a worksheet in Excel and, in Word, select Edit > Paste Special > Paste: > Microsoft Office Excel Worksheet Object.
In this way, I have no limits on the number of cells that appear.
I know definitively that this was a limitation in Office XP, where only a certain number of columns could be displayed.