On Oct 13, 2011, at 9:36 PM, Frank Missel wrote: > Interesting, how do you get the data from the table or view into Excel to be > the basis of the Pivottable? > Do you paste it to a worksheet (perhaps as arrays) that then becomes the > basis of the Pivottable?
Pivot tables can be populated from another worksheet, a data source, an OLAP cube, etc... > My problem is that the data basis of the Pivottable will sometimes be > millions of rows, i.e. many more than can be contained in a worksheet. > But when referencing the data source directly as a proper data source the > number of rows are not limited to the maximum number of allowed rows in a > worksheet. That number is pretty high these days, but yes there is no point using an intermediary worksheet. Get the data directly from source. Also, you may want to pre-process, e.g. summarize, your data in the database already as much as you can before hand. Excel is not a speed daemon when confronted with a truck load of data. You can also create and save the pivot table as an offline OLAP cube, with hierarchical dimensions & all (Microsoft Query + OLAP Cube Wizard). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
