Link a Table to External Data

Link a Table to External Data

Link a Table to External Data

 

Annotate Drawings > Tables > 

Link a Table to External Data

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

To link a table to a named range in Microsoft Excel

1. In your table, select the table cells to link.
2. On either the Table ribbon contextual tab or Table toolbar, click Link Cell.
3. In the Data Link Manager tree view, select Click to Create a New Excel Data Link.
4. In the Enter Data Link Name dialog box, enter a name for the data link. Click OK.
5. Click the [...] button to browse for the XLS or CSV file to link.
6. In the New Excel Data Link dialog box, select Link to a Named Range. Click OK.
7. Select the new data link in the Data Link Manager tree view. Click OK.

 Command entry: DATALINK