2012

■ 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
Imports data formats. Data is calculated from formulas in Excel.
Convert Data Formats to Text, Solve Formulas in Excel
Imports Microsoft Excel data as text with data calculated from formulas in
Excel (supported data formats not attached).
Allow Writing to Source File
Specifies that the DATALINKUPDATE on page 270 command can be used to
upload any changes made to linked data in your drawing to the original
external spreadsheet.
Cell Formatting
Use Excel Formatting
Specifies that any formatting specified in the original XLS, XLSX, or CSV file
will be brought into your drawing. When this option is not selected, the
table
style
on page 1201 formatting specified in the Insert Table dialog box on page
1200 is applied.
Keep Table Updated to Excel Formatting
If the option above is selected, updates any changed formatting when the
DATALINKUPDATE on page 270 command is used.
New Excel Data Link Dialog Box | 269