To install the add-in for use in Office Excel 2007
Download and install the Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists.
-
Start Office Excel 2007.
-
Click the Microsoft Office Button, click Excel Options, and then click the Add-Ins tab.
-
Select Excel Add-ins in the Manage drop-down list and click Go.
-
In the Add-Ins dialog box, click Browse, navigate to the Excel 2007 SharePoint List Synchronizing Add-in, and then click OK.
-
In the Add-Ins dialog box, verify that the SynchronizeWSSandExcel option is selected and then click OK.
Figure 1. The Add-Ins dialog with the Rwsplist option selected
Publishing and Synchronizing Table Data to a SharePoint Site
Using the add-in is simple, as you see in the following steps.
-
To add the add-in to a workbook Save the workbook in the Excel 97-2003 file format by clicking the Microsoft Office Button, pointing to Save As, and then clicking Excel 97-2003 Workbook.
-
Specify a file name, and then click Save.
-
Convert the range of data to a table: Highlight the table, choose Insert, Table, confirm the range for the table is correct, choose OK.
-
To publish the table to a SharePoint list: Highlight the table. The Table Tools label is displayed above the Design tab.
-
Click the Design tab.
-
In the SharePoint group, click Publish and allow Sync.
Figure 2. The Publish and allow Sync button on the Design tab
In the Export Table to SharePoint R/W List dialog box, in the Address text box, type in the page address on the SharePoint site where you want to publish the list.
Figure 3. The Export Table to SharePoint R/W List dialog box
In the Name text box, type in the name of the list and, optionally, type a description for the list.
Click Publish and navigate to the page that you specified earlier in SharePoint site and verify that the list published.
To update the SharePoint list
-
In the table in the workbook, make the changes to the data.
-
With the pointer in the table, right-click, point to Table, and click Synchronize with SharePoint.
Figure 4. The Synchronize with SharePoint option
In the browser, refresh the list and observe that the list reflects the changes.
Conclusion
although the ability to update SharePoint lists from Office Excel 2007 is deprecated in favor of publishing and synchronizing lists using Office Access 2007; you can use the Excel 2007 SharePoint List Synchronizing Add-in to update SharePoint lists from Office Excel 2007.