Link a Table to External Data
 
 
 

To set up a named range in Microsoft Excel

  1. In Microsoft Excel, open the workbook or spreadsheet that you want to access.
  2. Select a range of cells to function as a linked range.
  3. In the Name Box, enter a name for the range of cells, then press ENTER.
  4. Repeat steps 2 and 3, if desired, to specify additional linked ranges.
  5. On the File menu (Microsoft Excel), choose Save.