Forum Discussion
Linking Data From Excel to Access to Sharepoint List
Hi - I retrieve data in Excel. I am trying to create a link from this data to a Sharepoint List so that the data can be shared in a separate template that includes that data as a Power Query. If ...
Follow the steps in this article: https://support.office.com/en-gb/article/Export-a-list-to-Excel-in-SharePoint-Online-40f4b5cd-cb8a-4106-817e-4a0bf7cd68b5
If your list on the sharePoint gets updated, you will need to Refresh connection in excel in order to get the updated data from the SharePoint List.