In SharePoint 2013 how can I set up a Two-Way Auto Sync connection between 2013 excel file and sharepoint

Question

I am using Sharepoint 2013 , and there is a excel(2013) file with in the Sharepoint. I want to create a list by using some columns in the excel sheet, so after creating the list i want two way sync between the list and excel file ... i.e if i make any changes in list should appear in excel file and viceversa. Is there any way to do this? please comment your views.

Answer 1

There are several ways to synchronize data between a SharePoint list and a spreadsheet program. Whichever way you choose, this synchronization is one-way, or unidirectional. Changes made in the SharePoint list can be written to the spreadsheet program, but any changes that you make in the spreadsheet program are not written to the SharePoint list.

To synchronize a SharePoint list, you must have a compatible spreadsheet program, such as Excel 2013, installed on your client computer, and you must have read permission to the list.

Synchronize a list with a spreadsheet program

But to over come this, You can use add in called “Synchronizing Tables with SharePoint Lists”. What the add in does is it allows us to synchronize a SharePoint list with an Excel file.

Read complete here:http://sharepointrhapsody.com/2013/04/02/connecting-an-excel-sheet-to-sharepoint/