Unlink an Excel table from a SharePoint list

When you unlink a Microsoft Office Excel table (table: A collection of data about a particular subject that is stored in records (rows) and fields (columns).) that was exported to a custom list (list: A Web site component that stores and displays information that users can add to by using their browsers. Requires a Web server that is running Windows SharePoint Services.) on a Windows SharePoint Services site, the connection to that Windows SharePoint Services list is removed. The table will remain intact on the worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) 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.

  1. On the Design tab, in the External Data group, click Unlink.
Applies to:
Excel 2007