2012

Choose an Excel File
Allows you to choose an established Microsoft XLS, XLSX, or CSV file to link
to your drawing. At the bottom of this drop-down list, you can select a new
XLS, XLSX, or CSV file from which to create a data link.
Click the [...] button to browse for another Microsoft Excel file on your
computer.
Path Type Determines the path that will be used to find the file specified
above. There are three path options: full path, relative path, and no path.
■ Full Path. Uses the full path of the file specified above, including the root
directory and all subdirectories that contain the linked Microsoft Excel
file.
■ Relative Path. Uses the file path relative to the current drawing file to
reference the linked Microsoft Excel file. To use a relative path, the linked
file must be saved.
■ No Path. Uses only the filename of the linked Microsoft Excel file for
referencing.
Link Options
Specifies the data in your Excel file to link to your drawing.
Select the Excel Sheet to Link to
Displays the names of all sheets within the specified XLS, XLSX, or CSV file.
The link options specified below are applied to the sheet you choose here.
Link Entire Sheet
Links the entire specified sheet within your Excel file to a table in your drawing.
Link to a Named Range
Links a named range of cells already contained within your Excel file to a table
in your drawing.
Clicking the arrow displays the available named ranges found in the linked
spreadsheet.
Link to Range
Specifies a range of cells in your Excel file to link to a table in your drawing.
In the text box, enter the range of cells you want linked to your drawing. Valid
ranges include
■ Rectangular regions (for example, A1:D10)
268 | Chapter 5 D Commands