Tables

Revision as of 17:27, 16 March 2012 by Colin Overton (talk)

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

Calculations

Paging

Sorting

Pivoting

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