×
英语
很抱歉。本文没有你的语言版本。

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.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×