PivotTables and Calculated Items
XL97 W95
From a 700-row range, I create a PivotTable (VBA):
190 rows. From Excel, I add a calculated item (=add
the two other items of the field) : the re-calculation
of the pivot table never ends.
Is the Calculated Item feature very limited? Is it
my computer ('regular' pivots work usually very fast) ?
So far, I've never been able to use CalculatedItem (except
when testing it with 10-row range source). I usually have
to do it programmatically.
Does anybody knows how Pivot, Calculated Fields and
Items are computed?
Thanks,
Sebastien
Sent via Deja.com http://www.*-*-*.com/
Before you buy.