Link a Table to External Data
Expand All
Expand all collapsed sections.
Collapse All
Collapse all expanded sections.
ConceptProcedureQuick 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