Forum Discussion

Benedikt Scheerer's avatar
Benedikt Scheerer
Brass Contributor
Aug 22, 2017

Create list from Excel export - causes Errors within Sharepoint - Who can help?

Hello Community,   I wanted to create a list within Sharepoint (Office 365 E3). Background: The data for the list was already there in various Excel sheets.   My first approach: Copy and paste of...
2016
App
Lists
mobile
Matt Coats's avatar
Matt Coats
Iron Contributor
Aug 22, 2017

Let's take a look at the copy/paste method for a minute. Could you elaborate on how the copy/paste method didn't work? If you were trying to copy/paste a large amount of items (like several hundred at a time), I know from personal experience that this can cause SharePoint to just hang forever, especially if your table has a lot of fields.  If you haven't already, try copy/pasting a hundred or so records at a time.

 

I've no idea why your list created from an imported Excel sheet behaves that way, so I'm crossing my fingers for you that the copy/paste situation is salvageable.

Benedikt Scheerer's avatar
Benedikt Scheerer
Brass Contributor
Aug 23, 2017

Thanks Matt for your response. I tried the copy and paste option with my client's Sharepoint on premise solution - there it works. But not with my Office 365.

 

Attached a short demonstraion. when trying to paste, simply nothing happens :-)

Resources