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