ExcelCube application merges or consolidates entire worksheets across standard Excel workbook files without using linking formulas, add-ins, or macros. A Windows Explorer tree structure is used to organize workbooks into multiple groups, or levels of consolidation.

This structure is external to and independent of the workbooks themselves. All of the input data and consolidated results reside in stand-alone Excel files.

The input level workbooks and consolidated workbooks can be added, deleted, or moved around a structure using the mouse. This is done in the same way as moving files and folders in Explorer.

The structure makes up a cube of input level and merged workbooks, from which slices can be taken along any axis without programming.

The slice is placed onto a worksheet in a new workbook. The specification of what a slice contains can bechanged and re-run in seconds. This represents a deceptively simple OLAP capability.

Limitations: