Forum Discussion

PJB1961's avatar
PJB1961
Copper Contributor
Jan 21, 2025

List not saving

Hi,

I'm fairly new to using lists, I've tried to upload an excel file to lists, realising that the excel file being over 300 rows, I copied and pasted a lower amount of rows each time (using the add new item function). When I finally uploaded all rows and left the 'edit grid' none of the rows saved; can anyone tell me what I've done wrong?

microsoft lists

1 Reply

  • DaveMehr365's avatar
    DaveMehr365
    MVP
    Jan 22, 2025

    Hello PJB1961 

     

    maybe the type from the columns match not with the values. When SharePoint have a mismatch with one columns, the other will not be saving during import. 

    Try to use a set of less columns and grow to more. This way you can ensure that the correct data types are used.

     

    Best, Dave