2011

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)
■ Entire columns (for example, A:A)
■ Sets of columns (for example, A:D)
Click the button to the right of the text box to preview the linked range.
Preview Window
Displays a preview of your table using the options you have applied.
More Options
Displays more options. This button becomes available when you use an existing
Excel file or browse for a new one.
Cell Contents
Options in this box will determine how data is imported into your drawing
from your external source.
Keep Data Formats and Formulas
Imports data with formulas and supported data formats attached.
Keep Data Formats, Solve Formulas in Excel
New Excel Data Link Dialog Box | 449