Link a Table to External Data
 
 
 

To link to a table in an external spreadsheet

  1. Click ToolsData LinksData Link Manager.
  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.
 Toolbar: Table
 Command entry:  DATALINK
 Dashboard: Tables panel, Data Link Manager