How To Get Around “The Selected Cells Are Read-Only” When Pasting Into A Datasheet View…

I ran into an issue when trying to paste data into a datasheet view:

20140520Image02

All my columns seemed to be fine, and I know I had pasted items before. So I did a little research, and found it was a problem with multi-line text fields that were set for Enhanced Rich Text:

20140520Image01

If you have a column in the datasheet view that is set to Enhanced Rich Text, you get the read-only error. If I change that to Rich Text (or Plain Text), then I can paste in the new information with no problem.

Recording it here so I’ll remember it later. 🙂

4 responses to “How To Get Around “The Selected Cells Are Read-Only” When Pasting Into A Datasheet View…

  1. The problem is the column cannot be edited or deleted once this is set…

  2. For me, it seems to be all of the Person or group and TCC notify columns that get the read only error listed above. To determine this I tried pasting data into each field individually. The person/group/tcc notify columns were coming up as read only and wouldn’t let me paste anything into them. I am using SharePoint 2010 in datasheet view.

  3. Thanks for the information.

    Came in handy.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s