

This will synchronize the SharePoint list and excel data. Once you update data, You have to manually sync by right-clicking within the Excel table and select Table > Synchronize with SharePoint. That’s all! You can now update data either from Excel or from a SharePoint list. In design tab will see “Publish and allow Sync” button and fill SharePoint site details as below:Ħ. Now in Excel, Convert the data to the table (If it’s not table already) by selecting the data, click on Insert Tab, and choose “Table”.ĥ. Click on Browse Button and locate the SynchronizeWSSandExcel.xlam file, on the above location.Ĥ. Open Excel, Go to File > Options > Add-Ins, and click on the Go button next to “Manage: Excel Add-ins Dropdown.ģ. This will create SynchronizeWSSandExcel.xlam under: C:\2007 Office System Developer Resources\Code Samples\XL2007SynchronizeWSSandExcelĢ.
