8.5

• 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.
The Table Link dialog box
4
Click Browse to locate and select an Excel file to import.
5
If the file includes multiple worksheets, choose the one you want to import from the Sheet
drop-down menu. If you want to import only a portion of the data, you can specify a cell
range in the Range field or choose a named range from the drop-down menu.
6
In the Options area, check the attributes you want to import.
7
Click OK.
Formulas and references are not imported. Instead, the final values that result from formulas
and references are imported.Inserted pictures are not imported. Text with Auto Filter or
Advance Filter (Data > Filter) applied is imported as static text.
A quicker way to create a table from Excel data — without linking the source table to the
QuarkXPress project for updates — is to copy and paste. To do this, select any portion of
A GUIDE TO QUARKXPRESS 8.5: PLUS EDITION | 75
BOXES, LINES, AND TABLES