2011

By default, a data link is locked from editing to prevent undesired changes to
the linked spreadsheet. You can lock cells from data changes, format changes,
or both. To unlock a data link, click Locking on either the Table ribbon
contextual tab or the Table toolbar.
See also:
■
Extract Data from Drawings and Spreadsheets on page 1833
To link to a table in an external spreadsheet
1 In your table, select the table cells to link.
2 On either the Table ribbon contextual tab or Table toolbar, click Link
Cell.
3 In the Data Link Manager tree view, select Click to 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, do one of the following:
■ Select Link to a Named Range. Click OK.
■ 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.
Link a Table to External Data | 1403