To Link to a Table in an External Spreadsheet

  1. In your table, select the cells to link.
  2. On the Table ribbon contextual tab, click Data, Link Cell.
  3. In the Data Link Manager tree view, select 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 a link option. Click OK.
  7. Select the new data link in the data link tree view. Click OK.