+ Reply to Thread
Results 1 to 4 of 4

SharePoint List not updating from Excel Sheet

  1. #1
    Registered User
    Join Date
    11-18-2023
    Location
    Central Time
    MS-Off Ver
    2016
    Posts
    2

    SharePoint List not updating from Excel Sheet

    I have a simple Excel Sheet that has 2 columns, ID and Year. I already have 2 rows of data. I tried to export it to SharePoint. It was successful. But whenever I add a 3rd row of data in Excel Sheet, SharePoint List is not added of the same data from Excel Sheet.

    Please advise. Thank you.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,980

    Re: SharePoint List not updating from Excel Sheet

    Do you mean that you have an Excel file, and have exported it to SharePoint to convert it to a SharePoint List? I haven't used SharePoint for a couple of years. It might help if you gave more detail about what you are doing in SharePoint, but I don't think that you can link a List to an Excel file so that updates are synced between the two. The export is like a copy.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-18-2023
    Location
    Central Time
    MS-Off Ver
    2016
    Posts
    2

    Re: SharePoint List not updating from Excel Sheet

    The purpose of the Excel Sheet is that, it will become a multi-user sheet where one user can add data and reflect it in SharePoint so everyone will see that what they are inputting is seen in SharePoint.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,980

    Re: SharePoint List not updating from Excel Sheet

    I don't think you can use an Excel sheet that way. Why not just use the SharePoint list itself? I don't see the need for making an Excel sheet the data entry point.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to create Power Automate Flow for updating SharePoint list with a link
    By Underkarolinawood in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2021, 05:54 PM
  2. Updating/Deleting/Inserting Records in Sharepoint through Excel vba
    By sthiru in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2015, 01:06 AM
  3. Integrating excel with sharepoint and automatically updating an excel sheet
    By z-man in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 12:21 PM
  4. Updating excel sheet data to sharepoint list
    By swjnmdl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2013, 05:15 AM
  5. Replies: 0
    Last Post: 10-08-2013, 10:54 AM
  6. Updating List from SharePoint - buggy
    By dpenny in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2009, 12:21 PM
  7. [SOLVED] Sharepoint and updating of excel lists
    By Dave in forum Excel General
    Replies: 2
    Last Post: 06-22-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1