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.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language