Unlink an Excel table from a SharePoint list

When you unlink a Microsoft Office Excel table that was exported to a custom list on a Windows SharePoint Services site, the connection to that Windows SharePoint Services list is removed. The table will remain intact on the worksheet and the SharePoint list will remain on the SharePoint site, but you will no longer be able to update your table with changes that are made to the SharePoint list.

Important: After you unlink a table from its corresponding SharePoint list, the connection is lost permanently. You cannot undo unlinking or restore the connection.

1. In the worksheet, click anywhere in the table that you want to unlink from the SharePoint list.

   Tip: This displays the Table Tools, adding the Design tab.

2. On the Design tab, in the External Data group, click Unlink.