Table Properties

Behaviour Options

Excel

Resize columns/rows after refresh

Automatically adjust the columns and rows to fit the data.

Insert/delete columns/rows when Grid size changes

Determines the behaviour when rows are added or removed.

No Shift	XLCubed overwrites neighbouring cells.
Shift Range	XLCubed inserts the required number of cells only.
Shift Entire	XLCubed inserts and deletes entire columns or rows to accommodate the new data.

Fill formulae next to Table

Detect and fill down any formulae directly adjacent to the Table as rows are added or removed.

Refresh

Refresh Table on open

Causes the Table to update itself when the workbook is opened.

Appearance Options

General

Title

The title of the Table, displayed in dialogs and menus whenever the Table is referred to.

Formatting

Apply formatting

Override formats on the Table, or let you manage them manually.

Merge repeating cells

When data is repeated, merge the repeated cells for the outer values

With merged repeating cells

With separate repeating cells

Query Options

Auto-generate Query (default)

XLCubed controls the query for the Table given the selected options.

Manual Query

You may type your own query in the edit field.

Get Query from Excel range

The entire query statement for the Table is taken from a cell on the worksheet.

Performance tips for large tables

If you have very large tables, the following options will speed up data refreshes:

Turn off

• Resize Columns
• Apply Formatting
• Merge repeating cells