It’s best to paste when you have the row selected as shown here. If you click on it, it will select the entire row. Within the datasheet view, that little check mark contains a tiny empty box to the left of your data. In your list view, there should be a field with a little check mark, which is your selector field. In order words, don’t try to copy text into a date field, or a date into a people & groups field. You need to make sure that the column order in Excel matches that in SharePoint, and that the column types match too. Just a note: copying and pasting from Excel to SharePoint ONLY WORKS IN INTERNET EXPLORER, so if you find yourself trying this trick and it doesn’t work, check the browser you’re using. Either you created it there because it can be easier to work in Excel sometimes, or some emailed you a spreadsheet with information that you want to import into SharePoint. Oftentimes data is originally created in Excel. SharePoint’s Quick Edit, or Data Sheet view can be a lifesaver when you need to copy and paste lots of information at once.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |