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 to a table in an external spreadsheet

1. Click Annotate tabTables panelData Link. Enter datalink at the command prompt.
2. In the Data Link Manager tree view, click Create a New Excel Data Link.
3. In the Enter Data Link Name dialog box, enter a name for the data link. Click OK.
4. Click the [...] button to browse for the XLS or CSV file to be linked to.
   NoteTo link to the XLSX filetype, Microsoft Excel 2007 must be installed.
5. In the New Excel Data Link dialog box, select a link option (whole sheet, range, or Excel named range). Click OK.
6. Select the new data link in the Data Link Manager tree view. Click OK.

 Command entry: DATALINK