If the copy/paste is not successful, one of the following messages is displayed in the ribbon bar:
-
Cannot paste the selected cells:
-
Check you have selected destination cells.
-
Check that the selected cells are not in Edit mode.
-
Make sure that the selected destination layout matches the copied cells layout. The destination area needs to contain the same layout of rows and columns as the source.
-
-
Cannot set lookup value from different source:
You are trying to paste a value from a cell where the values are from a select list to a cell that cannot contain select list values. For example, a value copied from a select list of instrument manufacturers cannot be pasted to a cell with a select list of model numbers. You can only copy select list value to a cell with the same select list type or to a blank cell.
-
Cannot set value to read-only cell:
You are trying to paste a value into a cell whose properties have been set to read-only.
-
Item cannot be pasted into list:
You are trying to paste a value from a cell whose properties have a dependency on another property. For example, if a panel model in a particular cell is related to manufacturer Honeywell, it can only be pasted into another panel model cell for which the related manufacturer is also Honeywell.