2012

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 454 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 1889 formatting specified in the Insert Table dialog box on page
1888 is applied.
Keep Table Updated to Excel Formatting
If the option above is selected, updates any changed formatting when the
DATALINKUPDATE on page 454 command is used.
Start With Excel Formatting, Do Not Update
Imports the formatting specified in the original XLS, XLSX, or CSV file into
your drawing, but any changes made to the formatting are not included when
the
DATALINKUPDATE on page 454 command is used.
New Excel Data Link Dialog Box | 453