To Link Data in a Data Extraction Table to a Spreadsheet

  1. On the Refine Data page of the Data Extraction Wizard, click Link External Data.
  2. In the Link External Data dialog box, under Data LInk, click the Launch Data Link Manager button.
  3. In the Data Link Manager select Create A New Excel Data Link.
  4. Enter a name for the data link and click OK.
  5. Click the [...] button to browse for the .xls or .csv file to link to.
  6. In the New Excel Data Link dialog box, select a link option (whole sheet, range, or Excel named range), and click OK.
  7. Select the newly created data link in the Data Link Manager and click OK.
  8. In the Link External Data dialog box, under Data Matching, specify the columns (Drawing and External Data) to link.
  9. Click Check Match. If an error displays, see "About Linking Excel Spreadsheets."
  10. From the Select External Data Columns to Include, select more Excel columns to add to the extracted data.