How can I synchronize an external list with Excel 2013 in order to get two-way sync? Thanks.

Hi

You could create external list by Business Connectivity Service in SharePoint 2013:

https://support.office.com/en-sg/article/Create-an-external-list-6e2d601d-b02f-41e7-ba87-e70297ec6665

Quoted:

You can export data from an external list to Excel 2013 and keep the data synchronized. For example you may want to maintain a product inventory in an external list so that its easy to share and update, but also do periodic inventory analysis in Excel 2013.

From: https://support.office.com/en-in/article/Introduction-to-external-data-676e60e7-d99f-463f-a173-65e9d63538c0

Regards,

Rebecca, thank you for your answer. What I am trying to do is a two-way sync something similar to what it is possible with the SynchronizeWSSandExcel.xlam Excel 2007 Add-in, but rather than in a native list in an external list. My goal is not only fill up forms but also, in repetitive tasks, allow users to fill up directly from excel and keep the SQL Server database updated.

The following link to an MS Office article have a note that states: You can also synchronize an external list with Excel 2013. But there is not a See Also section. Maybe it refers to what you suggested in a one-way sync.

https://support.office.com/en-us/article/Export-an-external-list-to-Excel-fcbb5cdc-cf49-4131-8294-21bc25e66952

What I have proved is editing the external list form with InfoPath Designer 2013 and publishing it in SharePoint worked.

I am using SQL-Server 2014, SharePoint 2013, Excel 2013 and BCS

• Edited by LEAM.MX 16 hours 39 minutes ago