When you create a spreadsheet frame in a word processor document, you get 50 rows and 10 columns as a default size. If you try to resize the frame larger than that or if you try to paste more data than that, it will not work.
To enlarge the size of the frame, select the frame and go under the View menu to Open Frame. Then go under the Format menu to Document and increase the number of rows and columns to fit your needs.
This situation will sometimes occur when trying to resize across a page boundary. The issue is not the boundary; it is the default size of the frame.
There is an alternate method which allows the user to add 5 rows at a time to a spreadsheet frame of a word processing document without opening the frame.
Create the frame and expand it to 50 rows. Go under the Options menu to Frame Links. An arrow will appear at the bottom of the spreadsheet frame. Click the arrow and create a new spreadsheet frame with as many new rows (up to 5 additional) as you want. The first row will be row 51. Now go back and resize the first frame and then you can delete the second frame.