10.1

Importing Excel tables
Table data often originates in a spreadsheet program such as Excel, and you can import
table data just as you import pictures. Although the technique is slightly different, the
results are the same: The table in QuarkXPress is linked to the Excel file for tracking and
updating.
You can import both .xls and .xlsx files.
If you import a table from Excel using the Link to External Table feature in the Table
Properties dialog box, table usage will be tracked just as picture usage is tracked. This
ensures that you're notified if the source table changes, and that you have the latest table
data when you output the layout, whether you print, collect for output, save as a PDF, or
export to HTML. To check the status of a table, choose Utilities > Usage, and then click
the Tables tab.
Although you can update tables just as you can update pictures, you'll need to keep the
following points in mind:
• If you check Include Formats in the Table Link dialog box when you first import an Excel
table, the table's Excel formatting is preserved (as much as possible) in QuarkXPress. If you
later update the table, any local formatting you have applied in QuarkXPress is removed
and replaced with the formatting from the Excel file.
• If you do not check Include Formats in the Table Link dialog box when you first import
an Excel table, the table's Excel formatting is discarded. If you later update the table,
QuarkXPress attempts to preserve any local formatting you have applied to the table in
QuarkXPress.
To import an Excel table and maintain the link in QuarkXPress:
1
Using the Tables tool, drag to draw a table of approximately the dimensions you need.
The Table Properties dialog box displays when you release the mouse button.
2
Check Link to External Data.
3
Click OK to display the Table Link dialog box.
88 | A GUIDE TO QUARKXPRESS 10.1
BOXES, LINES, AND TABLES