Unlink an Excel table from a SharePoint list

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.