2012

Table Of Contents
8 In the Link External Data dialog box, in the Drawing Data Column list,
specify the column you want to link.
9 In the External Data Column list, specify the Excel column you want to
link.
10 Click Check Match. If an error displays, see Data Matching Validation.
11 From the Select External Data Columns to Include, select the Excel
columns from the list you want to add to the extracted data.
12 Click OK.
To set up a named range in Microsoft Excel to use in a data extraction
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 Enter a name for the range of cells in the Name Box, then press ENTER.
4 Repeat steps 2 and 3, if desired, to specify additional linked ranges.
5 On the File menu (Microsoft Excel), click Save.
To view the data link from a data extraction table to an Excel spreadsheet
Right-click the data extraction table. Click Properties.
The Cell Data Link field in the Properties palette displays the name of the data
link associated with the table.
To detach a link from a data extraction table to an Excel spreadsheet
Select the data extraction table and right-click. Click Data Links Detach
Data Link.
The data link to the Excel spreadsheet is removed from the data extraction
table.
1990 | Chapter 38 Extract Data from Drawings and Spreadsheets