QuarkXPress 10 Keeps Formatting when Updating Excel Tables

One of the new features in QuarkXPress 10 is that tables imported from Excel and formatted in QuarkXPress can now maintain the QuarkXPress formatting when the Excel table is updated.

The trick is to NOT include any of the Excel formatting when you first import the table — you can include the geometry, but then format the table in XPress.

To create a table in QuarkXPress and link an Excel spreadsheet to it, first get the Table tool:

Table Tool

Click and drag on the page to define an area for the table. Here’s what the first dialog box looks like after you do that:

Table Properties dialog-Link to external

When you check the “Link to External Data” checkbox and click the OK button, this dialog appears:

Table Link-no properties

Note that the “Include Style Sheets” and  “Include Formats” checkboxes are not checked. Browse to your Excel table and click the OK button to import it into the table on the QuarkXPress page.

When the original Excel table is changed, you can successfully update the table in QuarkXPress by choosing Utilities> Usage…

Usage>Tables>UpdateCookedBooks

… and your existing QuarkXPress formatting will still apply to the updated table!