1, first you look at the number of rows you are in, Excel2003 version of the maximum number of lines is 65536 lines. The maximum number of lines that Excel2007 starts is 1048576 lines, and if your data exceeds this limit, it's impossible to paste whatever you set it on.
2, to determine whether your worksheet is locked in the state, if it is locked, is not pasted. The workaround is simple, just click one of them and unlock the state.
3, when you paste is a table selected? If yes, do not select a cell, but select multiple rows, note that the entire row, and then paste.
4, in addition to paste the source cell lock situation, the solution: right-set cell format-protection, there is a "lock" button, remove.