Can we publish and synchronize excel 2013 table as SharePoint list. I understand that using export to excel functionality and using data connection changes in the list gets reflected in the excel. But wanted to check is it possible the other way (changes made in excel to list)
1 Answer
Yes, You can do it.But for a two-way synchronization you have to download a free Add-In from Microsoft. With this tool you have to create a list in Excel, publish it to a SharePoint list and synchronize with it.
Once you install it, then you should now see under the Design tab a SharePoint section with a button called Publish and allow sync. Please follow the below blogs for complete step by step process. Connecting an Excel Sheet to SharePoint
Note: even this is 2007 add in but works in 2013. You may need to restart you PC after add-in installation.
answered May 14, 2015 at 19:59
-
Thanks for the response, I tried the add-in and found few limitations.1. File has to be saved as 97-2003 file 2. Columns cannot be created in excel once the excel is published as list (new columns cannot be published to list) 3. formulas columns in excel become single line of text in the list 4. Doesn't work for excel with macros. So I wanted to check if there is any other alternative to this.– MeeMay 15, 2015 at 12:30
-
-
I know this is an old thread, but is there a way to accomplish this perhaps by using adodb?– WilliamFeb 6, 2017 at 21:27
-