Is there any row limit restriction while loading Compensation Worksheet?

We are trying to upload the mass data thru spreadsheet loaded into columns in Compensation Worksheet. However the warning window popps up. If we choose 'Yes" it updates only 3 rows out of 1100 rows. In case of choosing 'No" no data is uploaded. We have tested with couple of changes in worksheet and try to load, it works fine but when we consider mass data into 6 user-defined columns, the warning message appears as below:

Have any one experienced as such? We are in the event of annual remuneration, and we are facing challenging in this area. Please advise how to resolve this issue.