Forum Discussion
Updating SharePoint List from Excel
Hi Ryuojiin,
Could you copy paste the formula and the error message so that I can help you?
To update the SharePoint list from Excel, you have to click on the "Edit" hyperlink on any row/item to modify. This hyperlink open the "edit item" page on SharePoint. Modify the item and Save it. Go back to Excel and refresh the table. Your data is updated in Excel.
You can of course modify serval items one by one, using their respective "Edit" hyperlink, and update the Excel file from times to times.
No video yet, sorry!
Keep me updated 🙂
Sylvie_in_France Here's my formula -HYPERLINK(urlEdit&[@ID,"Edit") I put on the cell and I do have the 2 of the urls and named them as you told like urlNew and urlEdit.
I get the error:
The syntax if this name isn't correct.
Verify that the name:
- Starts with a letter or underscore (_)
- Doesn't include a space or character that isn't allowed
- Doesn't conflict with an existing name in the workbook.
Also another question, one of my fields in the sharepoint gets info from a distribution list, will doing this affect updating the list?
- This appears to export the SharePoint list items to the Excel table. That is not what we want. We want to export our Excel table to a SharePoint list and then update SharePoint list from the Excel table whenever the Excel table is updated.
- The closing square braket is missing: [@ID]
If you're not used to working with data tables and structured references, you should watch a video about it, for example https://youtu.be/C6f3_gCNz-U.
I don't know the answer of the other question.
Best
