To Link to a Table in an External Spreadsheet
In your table, select the cells to link.
On the Table ribbon contextual tab, click Data, Link Cell.
In the Data Link Manager tree view, select Create a New Excel Data Link.
In the Enter Data Link Name dialog box, enter a name for the data link. Click OK.
Click the [...] button to browse for the XLS or CSV file to link.
In the New Excel Data Link dialog box, select a link option. Click OK.
Select the new data link in the data link tree view. Click OK.
Related Concepts
About Linking a Table to External Data
Related Tasks
To Remove a Link to an External Spreadsheet
To Open an External Spreadsheet From a Data Link
To Set Up a Named Range in Microsoft Excel
Related Reference
Commands for Tables