I'm trying to copy/paste new rows into an existing SP list - the first column is a look-up column.
I noticed a few changes to the list:
I tried to manually create a new row in 'Edit in Grid View'. I'll select an entry in the lookup column - but it will not save the new row.
Interestingly, if I click 'do not save changes' - it will actually save that (first) row.
Can anyone help?