After you export a Microsoft Office Excel table to a Windows SharePoint Services list and create a connection to that list, you can update the table data to incorporate changes that are made to the SharePoint list. You cannot update data in the SharePoint list to incorporate changes that you make to data in the Excel table.
Important Updates from a SharePoint list overwrite the original exported data in addition to any changes that you made to the table data in the worksheet after you exported it to the SharePoint site.
- In the worksheet, click anywhere in the table that you want to update.
Tip This displays the Table Tools, adding the Design tab.
- On the Design tab, in the External Data group, click Refresh.
