Missed that line asking for a workaround :/


Posted by Eric on October 09, 2001 3:53 AM

If the data on which you were pivoting was both numeric and resulted in I guess three different tactics would be:

a) "simplify/chunk" the data that is giving you more than 8000 rows of output.

b) eschew the pivot table all together and use array (CSE) and/or sumif/countif formulae to generate the same information. I'm not sure what 8,269 array formulas would do to your machine's performance, so be careful! I think array-based formulae are slower than pivot-table based calculations, but do not have the 8000 row limit.

c) pivot on subsets of the list

If you posted some sample data, especially of the column generating the 8000+ unique rows, you could probably get more targeted advice.

HTH



Posted by Eric on October 09, 2001 3:56 AM

Ignore above, mis-posted :P (NT)