SharePoint List synchronization with Excel 2010

[Kramfors]

Hi all,

I have an existing SharePoint list which I would like to update within Excel 2010.

I know that this feature no longer exists natively in Excel 2010, so I installed the SharePoint List Synchronizing Add-In as indicated here. I have read around the web that this Add-In should also work for Excel 2010.

I can see the "Publish and allow Sync" button in the Table Design tab (see Figure 2), but the "Synchronize with SharePoint" option (see Figure 4) does not appear in the drop-down menu when I right click on the table I want to update to SharePoint.
Apparently, this is the only way to update an existing SharePoint list from Excel 2010.

Do you know why this button does not show up after installation of the Add-In?

Thanks for your help!

 

[Kramfors]

Hi all,

In case someone comes across this topic, I have found the solution after multiple tries!!

If you want to update data from Excel 2010 to SharePoint, you can only do this if you created the list with the SharePoint List Synchronizing Add-in.
You literally need to create the list with the add-in to establish the connection in the file. Then only the "Synchronize with SharePoint" option will appear, and you will be able to push/pull data from Excel to SharePoint.
If you create the List in SharePoint or without the add-in, you will not be able to push data from Excel.
Also, the file needs to be saved in .xls format to keep the connection.

Note that you can always modify the list fields in SharePoint after it has been created using the add-in.
Additionally, Users should be given access at Site level, and not only at List level, otherwise, the synchronization will fail.

I hope this will help other users!