Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!