Choose the default behavior when you link data in the External Data window to previously linked shapes

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

You cannot link two rows from the same data source to the same shape. If you try to add a second link from the same source, you are prompted to choose whether to replace the existing link. If you don't want to be prompted each time, you can change this default behavior.

  1. Right-click the tab for the data source that you want to change, and then click Properties.

  2. In the Data source Properties dialog box, select one of the following options:

    • Prompt me when linking to a shape with existing links

    • Always replace existing links when linking

    • Never replace existing links when linking

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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!