2012

Table Of Contents
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.
To remove a link to an external spreadsheet
1 Click inside a cell within the data linked table to select the cell.
2 Right-click and click Data Links Detach Data Link.
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.
To open an external spreadsheet from a data link
1 Select any cell in the linked table or range of linked cells.
2 Right-click and click Data Links Open Data Link File.
Quick Reference
DATALINK
Displays the Data Link dialog box.
DATALINKUPDATE
Updates data to or from an established external data link.
DATALINKNOTIFY
Controls the notification for updated or missing data links.
1510 | Chapter 30 Tables