Troubleshoot moving, copying, and pasting cell contents in Datasheet view
I cannot paste data in a column, or I get the message "N cells could not be pasted".
Do one or more of the following:
- Make sure the column is not a calculated column.
- Make sure the type of data you are attempting to paste matches the type of the destination cells.
- Make sure the validation rules set for a cell or a row will not be violated by the paste operation.
I get the message "Some data was truncated".
You are attempting to paste more characters than are allowed in one or more of the destination cells. For example, if you try to paste more than 255 characters in a cell of type single-line of text, the extra characters will be truncated.
I get the message "Cells in the region are required and cannot be cleared".
You are attempting to move one or more cells in a column that is marked required. A required column cannot be left blank; instead of trying to move data, try copying the data to the destination, then delete unwanted rows.
I get the message "Cells/Rows in the region are read-only".
You are attempting to move data from one or more cells or rows that are read-only, or paste data in cells or rows that are read-only. You cannot change the contents of read-only cells and rows.
I get the message "Cannot be pasted because the paste area is not completely on the list".
This could be due to one of the following reasons:
- You are attempting to paste one or more rows into a cell other than the first cell of a row.
- You are attempting to paste a range of cells into a cell, but the view does not have the required number of rows and columns to the right and bottom of the destination cell.
You are attempting to paste a range of cells into a destination range, but the dimensions do not match. Make sure you select the same number of rows and columns in the destination range as in the source range.
I get the message "Some rows were skipped".
This could be due to one of the following reasons:
- You attempted to copy one or more columns into a cell other than the first cell in the destination column.
- You attempted to paste data into the star (*) row, but the operation does not add data to all the required columns in the view.
Any operation that requires new rows to be added but leaves the required columns empty, will fail. The paste operation only succeeds on existing rows, while the remaining rows are skipped.