GETPIVOTDATA Excel 2000

Louja · External Since: May 02, 2009 Posts: 1

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 · External Since: Jan 09, 2009 Posts: 56

Hi

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

--
Regards
Roger Govier

"Louja" <louisa.c.thompson.TakeThisOut@googlemail.com> wrote in message
news:9048d247-a2fa-4396-9be0-9ac14571cc52@n8g2000vbb.googlegroups.com...
> 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