Hide columns in the External Data window and in linked shapes

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.

Hiding a column in the External Data window also hides the data in the linked shapes. For example, if you hide a Salary column, all mentions of Salary in shapes that are linked to the data are also hidden.

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

  1. Right-click any column heading in the External Data window, and then click Column Settings.

  2. In the Column Settings dialog box, clear the check box of the column that you want to hide.

To show the column in the External Data window and in the linked shapes again, select the check box.

For more information about working with imported data, see Import data from Excel, SQL Server, SharePoint sites, 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.

×