Merge Excel Files

Consolidate & Merge Excel Workbooks. No Formulas, Add-ins, or Macros

BUY Excel Cube <See Also: Spreadsheet Consolidator & Advanced Excel Consolidate & Excel Fusion>

Add entire spreadsheets across dozens or hundreds of workbooks.

Report aggregate and input workbooks on a single spreadsheet.

Excel-Cube 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.

After changes are made to the structure, the results held in the consolidated workbooks are updated in a few seconds.

In Excel-Cube, the folders are more than a name for the group of files below them. They also represent the workbooks holding the results of the consolidation of the workbooks below them. Excel-Cube creates these workbooks every time the structure is calculated.

A single application can organize the same input-level workbooks into several different and independent structures. Different consolidations can be made without any duplication of data.

Excel-Cube's protocol is simpler and vastly more productive than using linking formulas or add-ins to add portions of a worksheet across a handful of workbooks.

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 be changed and re-run in seconds. This represents a deceptively simple OLAP capability. This feature is referred to as a Cross Section in Excel-Cube.

All of the worksheets and in the workbooks can be changed by editing the worksheets in a single workbook. This is a centralized, one step Maintenance capability comprising a huge time saver by itself.

Requirements

Excel-Cube will work on Windows 98, ME, 2000, NT, or XP operating systems with one of the Microsoft Excel versions, 97 through 2003, installed. Excel-Cube also requires the new .NET Framework 2.0 installed. The Excel-Cube installation will install .NET Framework automatically if it is not on the user's system.

More On Excel Cube: Excel Consolidation Example | Excel Cube Structure | Cross Section | One Step Maintenance | Watch Flash Video (requires Flash Player)

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

Excel Cube $95.00 Payment Problems/Options. Refund Policy: Our objective is to have Excel-Cube serve as a productive tool. If there is any reason it does not work to the user's satisfaction we would like to know. In this event a full refund will be made.

Excel Cube LITE $55.00 The Lite version only uses one worksheet per workbook file

See Also: Excel Add-ins Index, Over 200!

Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft Ž and Microsoft Excel Ž are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft