Link a Table to External Data
 
 
 

To link a table to cells in Microsoft Excel

  1. In your table, select the table cells to link.
  2. On the 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 be linked to.
  6. In the New Excel Data Link dialog box, select Link to Range. Enter a valid range from the Excel spreadsheet (for example, A1:D17). Click OK.
  7. Select the new data link in the Data Link Manager tree view. Click OK.
 Toolbar: Table
 Command entry:  DATALINK
 Dashboard: Tables panel, Data Link Manager