Unlink shapes from data in the External Data window

Office 365 Subscription, Office 2019, Office 2016, Office 2013, Office 2010

The External Data window appears automatically after you have successfully linked shapes in your Visio drawing to an external data source such as Excel spreadsheet, Access database, SQL Server database, SharePoint list, an OLEDB or ODBC data source, to name a few.

Note: To display the External Data window, on the Data tab, select the checkbox next to External Data Window.

Unlink rows from shapes

  1. In the External Data window, select the row or rows that you want to unlink.

  2. Right-click any of the selected rows, and then click Unlink.

Unlink shapes from rows

  1. In your drawing, select the shape or shapes that you want to unlink.

  2. Right-click any of the selected shapes, point to Data, and then click Unlink from Row.

Note: To display the External Data window, on the View menu, click External Data Window.

Unlink rows from shapes

  1. In the External Data window, select the row or rows that you want to unlink.

  2. Right-click any of the selected rows, and then click Unlink.

Unlink shapes from rows

  1. In your drawing, select the shape or shapes that you want to unlink.

  2. Right-click any of the selected shapes, point to Data, and then click Unlink from Row.

See Also

Tips and tricks for linking data

Import data to shapes in your drawing

Import data from Excel, SQL Server, SharePoint, and other external sources

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.

×