Tables

Introduction

XLCubed tables can be inserted from several sources; multidimensional and tabular cubes, and Sql data sources.

Once the table has been inserted, several features are available which apply to all tables.

Formatting

As with grids, formatting for tables is defined on the XLCubedFormats worksheet.

Tables will automatically pick up the default formatting for the column headers and data area.

In addition you can also define formats that will only apply to certain sections of the table.

Formatting Values

You can highlight specific values in a table by entering the column name and value, and setting the data cell format. The following example highlights December in red, and makes months starting with "A" bold.

You can also format specific columns. To do this type the word "Column" as the column name, and then the name of the column. You can the format the header and data areas. The following example makes the "Initial Agency Value" header bold, and uses currency formatting for the data.

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