GETPIVOTDATA Excel 2000
 

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

GETPIVOTDATA Excel 2000
 

Hi

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

--
Regards
Roger Govier

"Louja" wrote in message
...
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