Change which column uniquely identifies each row in the External Data window

The External Data window appears when you use the Link Data to Shapes command on the Data menu to import data into your drawing.

  1. Right-click anywhere inside the External Data window, and then click Configure Refresh.

  2. In the Configure Refresh dialog box, under Unique Identifier, select the column that you want to use to identify each row in your data.

For more information about working with imported data, see Import data from Excel, SQL Server, SharePoint sites, and other external sources.

Expand your 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.