This is hard to explain, but I'll do my best.

  1. I have a SP list where I update the data from an excel file and copy&paste it into the datasheet view of my SP list.
  2. I have a SP custom view of this list that only shows a handful of the columns available.
  3. I then have added 2 columns of additional data to each entry in this SP list.

Question: To maintain my data I regularly have to copy&paste the excel data as in step 1. If rows are added/removed, will the data in the columns from step 3 still retain their association to the correct data? And if not is there a way to do this?

1 Answer 1


The answer is no, and I can't think of a way to do this in datasheet view. It would be easy enough to do programmatically, as long as you can uniquely pair rows in the spreadsheet to rows in the list (i.e. some column value, or combination of column values, will be unique).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.