GETPIVOTDATA Excel 2000

[Louja]

Hi,

I am trying to do GETPIVOTDATA on Excel 2000 with more than one
field. This is because I did originally set my formula up as a
SUMPRODUCT but because I had over 10,000 of these formulas it kills my
laptop.

Any other suggestions. One of the reasons I was using SUMPRODUCT in
the first place was because I had some lookup tables with more than
one variable and could not think of another solution.

Thanks

 

[Roger Govier]

Hi

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlPivot06.html