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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×