Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA....Excel 2000....Desperation! | Excel Worksheet Functions | |||
getpivotdata function with Excel 2000 | Excel Discussion (Misc queries) | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Getpivotdata - Excel 2000 vs. Excel 2002 and later | Excel Worksheet Functions | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions |