Have you considered Access as a better tool for the job?

Regards.

Bill Ridgeway
Computer Solutions

2007?

Try this one:

DataTime Documentation
http://cam70.sta.uniroma1.it/DataTimeDocumentation/

DataTime Universal (downloadable)
http://cam70.sta.uniroma1.it/DataTimeUniversal/

It's time to rethink the tool or the use of the tool.

1. Excel 2007 from my simple tests, accommodates heaps more rows and
columns and calculates faster because it can use the second core of a
modern dual core PC.

2. Pivot Tables are really cool and powerful but if your dataset
becomes very big, the Pivot Table no longer is able to provide it's
features which is based on keeping all the data in memory.

3. For large datasets you can use Access - and there are Pivot
features in Access 2003 as well, although not as powerful as Excel
(AFAIK). Access does not usually run slower as you add more data,
unlike Excel.

4. If your dataset is very big and your pivot parameters are numerous,
you will want to sit down and engineer the solution using Data
Analysis Cubes - in which case, you are looking at Microsoft SQL
Server Data Analysis tools - you make optimised OLAP Cubes in a
designer, store it in SQL Server. Then you use Excel to connect to
those Cubes and pluck out the reports. It is very much more formal,
needs this infrastructure, but the speed is very fast in execution.

5. Whatever design you use in the "back end", you can produce Excel
summaries and subsets to deliver to people who do not have / want the
infrastructure.

HTH
Ananda